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 [...]
Posts Tagged ‘SQLAgentReaderRole’
SQLAgentReaderRole – not so reader?
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) [...]
