Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to view SQL Server Agent while logged in Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 12:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 7, 2012 2:26 PM
Points: 8, Visits: 30
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?
Post #724470
Posted Wednesday, May 27, 2009 5:10 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:14 PM
Points: 4,064, Visits: 5,319
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
Post #724689
Posted Friday, May 29, 2009 7:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 7, 2012 2:26 PM
Points: 8, Visits: 30
thank you. will try this and see if it works. Thanks

Tina
Post #725765
Posted Wednesday, April 11, 2012 8:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:02 AM
Points: 5, Visits: 86
It worked.. Thanks.
Post #1281560
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse