<p>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 <code>sysadmin</code> rights.  I know that in <code>SQL 2005</code>, you can grant them the <code>SQLAgentReaderRole</code>, but I am looking for a solution in <code>SQL 2000</code>.  </p>

[{'answer_id': 67550, 'author': 'Jody', 'author_id': 10235, 'author_profile': 'https://Stackoverflow.com/users/10235', 'pm_score': 2, 'selected': False, 'text': '<p>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.</p>\n\n<p><a href="http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&amp;threadid=43021&amp;enterthread=y" rel="nofollow noreferrer">http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&amp;threadid=43021&amp;enterthread=y</a></p>\n'}, {'answer_id': 5421141, 'author': 'J Schafer Wilson', 'author_id': 358651, 'author_profile': 'https://Stackoverflow.com/users/358651', 'pm_score': 0, 'selected': False, 'text': '<p>Looks like there\'s some hope for those of us still working with 2000 -</p>\n\n<p>"In order to accomplish this in SQL Server 2000 the DBA must add the user to TargetServersRole role in MSDB database. Prior to Service Pack 3 on SQL Server 2000 the user must be added to the sysadmin group in order to get a chance to view the jobs that are owned by sysadmin group."</p>\n\n<p>Quoted from <a href="http://www.sql-server-performance.com/faq/sqlagent_scheduled_jobs_p1.aspx" rel="nofollow">http://www.sql-server-performance.com/faq/sqlagent_scheduled_jobs_p1.aspx</a> via <a href="http://social.msdn.microsoft.com/Forums/en/sqlsmoanddmo/thread/8a05fe47-50c7-4b95-b631-8f7d69d31dae" rel="nofollow">http://social.msdn.microsoft.com/Forums/en/sqlsmoanddmo/thread/8a05fe47-50c7-4b95-b631-8f7d69d31dae</a></p>\n'}]
['https://Stackoverflow.com/questions/67347', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']