Role or permission to view but not create SQL Agent jobs The Microsoft SQL Server database role SQLAgentReaderRole apparently lets a member create SQL Agent jobs along with viewing jobs, job steps, and results.  

We need to allow a user to see all SQL agent jobs, steps, schedules, and results, but not create any jobs.  This can almost be provided using several different views, but the results are messy and hard to read -- I want to be able to see the SQL Agent node in Management Studio and verify things.

Is there any role or permission that would allow this?  Let's assume SQL 2008 through SQL 2016.  Thanks.
Seems like this should work:


  The "reader" name is definitely misleading. This may be stating the
  obvious, but to get around this I've granted the SQLAgentReaderRole
  role and explicitly denied EXECUTE on add job sprocs in msdb for the
  logins with the role. 

DENY EXECUTE ON [dbo].[sp_add_job] TO [YourLogin] GO 
DENY EXECUTE ON [dbo].[sp_add_jobschedule] TO [YourLogin] GO 
DENY EXECUTE ON [dbo].[sp_add_jobserver] TO [YourLogin] GO 
DENY EXECUTE ON [dbo].[sp_add_jobstep] TO [YourLogin] GO 
DENY EXECUTE ON [dbo].[sp_add_jobstep_internal] TO [YourLogin] GO