SQL Server Role to View Job Logs

roleSecuritysql-server-2005sql-server-2012users

We have a monitoring tool that can check if Microsoft SQL Server jobs have run successfully. What I want to do is create a user that has as little permission as possible but it must be able to watch the history log to see if the job completed.

What role should I assign the user?

Edit:
The servers are Microsoft SQL Server 2005 to 2012

Best Answer

To be able to check all jobs you would need go add the user to the SQLAgentReaderRole in the msdb database which also gives that user permission to create jobs. To minimize the access granted you can also grant the user select permission on the tables used by the sql server agent