Posts Tagged ‘SQLAgentReaderRole’

So if you follow me blog you will probably remember this post from earlier today:
http://benchmarkitconsulting.com/colin-stasiuk/2009/01/21/sqlagentreaderrole-not-so-reader/
Below is the solution I’m working with to give developers access to the Job Activity Monitor but NOT the ability to create new jobs.
I know adding a role to a system database is not ideal but I’m open to other suggestions [...]

Quick… how do you give someone read only access to the Job Activity Monitor?
Why you grant them SQLAgentReaderRole access in msdb…. WRONG
http://technet.microsoft.com/en-us/library/ms188283.aspx
The SQLAgentReaderRole is a reader role for the jobs that currently exist but wait here is where the good (or bad depending on if you’re in a good mood or not) part comes in.
Me [...]