What kind of security do I need to see jobs in Ent Mgr (SQL 2000)

[bessebo]

We are currently undergoing a change due to Sarbanes-Oxley. What I have been asked to do is to not automatically log onto Enterprise Manager as 'sa'. So I have created a user called 'dbreader' that has database addess of db_datareader. The thing is that if I set up the user this way I cannot see the SQLServer jobs. I assume that I also have to set up a server role for this login. I am thinking that I may have to use Setup Administrator. Anyone know what type of security I will have to use so that I can at least see the SQLServer jobs?

Thanks,
Bessebo

 

[drtree]

Hey,

Check this link out -

http://www.sql-server-performance.com/faq/sqlagent_scheduled_jobs_p1.aspx

HTH,

Doc Tree

 

[bessebo]

Thanks very much Doc Tree. That worked!

Regards,
Bessebo