Post reply

SQL Agent Access to modify Job

  • October 23, 2014 at 2:21 pm

    #297782

    hi Team,

    M trying to figure out what access right require to login to modify Jobs.

    i have tried giving db_owner to MSDB along with

    SQLAgentOperatorRole

    SQLAgentUserRole

    still not able to modify SQL agent job owned by other users.

    any help would be appreciated.

  • October 23, 2014 at 8:47 pm

    #1754527

    From memory, to change a change owned by another user, you need to be a sysdamin. Have a read of http://msdn.microsoft.com/en-us/library/ms188283.aspx for more info

  • October 27, 2014 at 4:20 pm

    #1755060

    yes I Did go through the article, but trying to see if we have any other solution available.

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

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