Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sean_B
Posting Yak Master
111 Posts |
 Posted - 2010-03-01 : 06:42:36
|
| Hi,I've a user who is a job owner but is unable to edit the job schedule.They are a member of a group which is a member of the role sqlagentOperatorRole.Can anyone advise on what I need to change or query, this is unfamiliar territory.thanksSean |
|
|
Sean_B
Posting Yak Master
111 Posts |
Posted - 2010-03-01 : 07:13:44
|
| Hi,I scripted the job as a create, then dropped it from the object explorer, and then ran the create script after using execute as user = '....', the job owner and it worjked. It recreated the job and the schedule with the same user. Obviously the job owner had got changed at some point.thanks.Sean |
 |
|
|
|
|
|
Unable to edit job Schedule