Post reply

Unable to view SQL Server Agent while logged in

  • May 27, 2009 at 12:54 pm

    #221665

    Hi All,

    I have asked the DBA to grant me access to SQL server agent so I can view jobs, but this seems this can't be accomplished. I have Microsfot SQL server management studio 2005. Does anyone know what config and/or installation is required to be able to view SQL Server agent?

  • May 27, 2009 at 5:10 pm

    #1001125

    There's a fixed database role in msdb whose members can list and view the properties of jobs, but doesn't allow editing the properties. It's called SQLAgentReaderRole. Ask you DBA to consider adding you to the role. He or she might not like using it because it allows members to create jobs, so you may have to work that out.

    Greg

  • May 29, 2009 at 7:03 am

    #1002014

    thank you. will try this and see if it works. Thanks

    Tina

  • April 11, 2012 at 8:12 am

    #1471866

    It worked.. Thanks.

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

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