Post reply

Rights to Run Agent Jobs

  • March 9, 2016 at 12:29 pm

    #324813

    We want our Data Center people to be able to manually run an Agent Job on a SQL 2012 instance when the scheduled run fails.

    I have added an Active Directory security group with these people as a Login mapped to a MSDB user with membership in the SQLAgentOperatorRole. My understanding is that they should be able to see Agent Jobs in SSMS and manually run them. But they are not seeing Agent at all in SSMS.

    What am I missing?

  • March 9, 2016 at 1:11 pm

    #1864097

    dan-572483 (3/9/2016)

    We want our Data Center people to be able to manually run an Agent Job on a SQL 2012 instance when the scheduled run fails.

    I have added an Active Directory security group with these people as a Login mapped to a MSDB user with membership in the SQLAgentOperatorRole. My understanding is that they should be able to see Agent Jobs in SSMS and manually run them. But they are not seeing Agent at all in SSMS.

    What am I missing?

    Check out - http://dba.stackexchange.com/questions/56823/how-do-i-get-sql-server-agent-to-show-up-in-ssms-for-a-non-sysadmin-user

    Tommy

    Follow @sqlscribe

  • March 9, 2016 at 2:23 pm

    #1864112

    Fixed it. The issue was that I used an AD Group with a slightly different name from the one the users are in. Lesson: try not to take specs over the phone!

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

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