Unable to view SQL Server Agent while logged in

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » Unable to view SQL Server Agent while logged...

Unable to view SQL Server Agent while logged in

Rate Topic

Display Mode

Topic Options

Author

Message

Candls

Posted Wednesday, May 27, 2009 12:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 07, 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

Greg Charles

Posted Wednesday, May 27, 2009 5:10 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:34 AM
Points: 4,007, Visits: 4,857

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

Candls

Posted Friday, May 29, 2009 7:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 07, 2012 2:26 PM
Points: 8, Visits: 30

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

Tina

Post #725765

rderisala1

Posted Wednesday, April 11, 2012 8:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:57 PM
Points: 4, Visits: 73

It worked.. Thanks.

Post #1281560

« Prev Topic | Next Topic »

Permissions