SQL 2000 equivalent of SQLAgentReaderRole

Question

I have quite a few developers asking me if certain SQL jobs ran, and I would like to give them access to check it on their own without giving them 'sysadmin' rights. I know that in SQL 2005, you can grant them the SQLAgentReaderRole, but I am looking for a solution in SQL 2000.

Answer 1

Pretty sure there isn't one out of the box. This thread seems to be pretty decent...halfway down they discuss creating a role and then locking that down further. Also you could just create a mini-program (sp even?) to email the results of the job as a summary, or add to each job an on completion event to email an email group.

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=43021&enterthread=y