October 2, 2009 at 8:51 am
Hi,
Is there any specific role that needs to be assigned to a user to change the schedule of a Sql server job who is not sysadmin.
I get the following error:
Only a owner of the job schedule or sysadmin can modify or delete the job schedule
I cannot make the user either the owner or Sysadmin....
The use has security admin role
October 2, 2009 at 9:07 am
Use a SQLAgentUserRole (msdb fixed database role) if you need your user working on his own jobs only.
Use a SQLAgentOperatorRole (msdb fixed database role) if you need your user working on all jobs.
Just assign the user to one of these roles.
October 2, 2009 at 9:20 am
I did....but it doesnt seeem to work....
I beleive the roles are the 'Jobs owned by the user only'. I need the user to be able to change the schedule for all the job created by him and others.
October 2, 2009 at 9:27 am
As I said use a SQLAgentOperatorRole (msdb fixed database role) if you need your user working on all jobs, created by any user.
Look at this:
http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx
October 2, 2009 at 9:33 am
I tried that ...the user is using windows authetiaction and tried giving the user all the SQL operator roles....doesnt seem to work....
In the link for schedules it say 'Yes (owned schedules only)'. Does it mean that the schedules owned by the user????
Assigned roles(attached)
October 2, 2009 at 11:17 am
SQLAgentOperatorRole members can enable or disable schedules they do not own by using the stored procedure sp_update_schedule and specifying values for the @enabled and the @schedule_id (or @name) parameters.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply