Post reply

SQL Agent Job

  • November 20, 2008 at 8:13 am

    #194208

    How could i give permissions for a develoepr to edit sql agent job in 2005.

    I have a user where i gave him dtsadmin,SQLAgentoperatorrole,Readerrole,Userrole on 2 of the servers but on 1 of them he can not edit the job. what wud be the reason.

    thanks

  • November 20, 2008 at 9:08 am

    #901112

    The user has to be the owner of the jobs to edit them. Only members of sysadmin can edit jobs they don't own. It won't even work to give him EXECUTE permission on the system stored procedures because the procs check to see if the user is the job owner or is a member of sysadmin.

    Greg

  • November 20, 2008 at 9:30 am

    #901128

    Here on both servers the User owns those jobs but still cant edit. any clue.

  • November 20, 2008 at 9:42 am

    #901146

    You may need to add user to SQLAgentUserRole ....

    http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply