Post reply

sql server agent does not show up on sql2008 database

  • July 29, 2011 at 5:17 am

    #254485

    I just got permissions to view a corporate db and in a classic case of "it works here", a coworker can see the sql server agent on their connection, but I can't. And of course, I do want to see it when there's an error running a job. Since I work remotely, it would be nice to have a solution ready by the time everyone else walked in.

    Is this because I don't have permission to view it? Or is it something I need to set up myself? We're on SQL2008-R2.

  • July 29, 2011 at 5:32 am

    #1360687

    You need to ask your DBA to provide you SQLagent user and SQLAgentReader role in MSDB database. then you will be able to see the agent in the management studio.

    Chandan

  • July 29, 2011 at 5:41 am

    #1360689

    chandan_jha18 (7/29/2011)

    You need to ask your DBA to provide you SQLagent user and SQLAgentReader role in MSDB database. then you will be able to see the agent in the management studio.

    Chandan

    Okay - I'll try. Thanks! I work remotely so I have to wait for someone to come in but I'll let you know if it works.

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

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