Post reply

View SQL Agent Jobs Without the SA Role

  • May 4, 2004 at 11:42 am

    #85316

    Our DBAs have dbo privileges in our databases and can pretty much do all of our work with these permissions.

    However, we need to be able to view the SQL Agent jobs via Enterprise Manager without logging on to an

    account that has SA privileges.  Does anyone know of a way to do this?

     

    Thanks, Lloyd

  • May 5, 2004 at 1:26 pm

    #505363

     Make the user member of "TargetServerRole" in msdb and that should do it.

  • May 6, 2004 at 11:49 am

    #505529

    Excellent!  Thank you for sharing the knowledge.

    Lloyd 

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

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