Permissions to view jobs

• Niclas Westerberg

  Newbie

  Points: 3

  More actions

  June 12, 2008 at 8:01 am

  #77016

  What permissions is needed to view jobs in Enterprise Manager? I have created a domain account, added it in logins and want it to be able to view databases, linked servers and jobs. The problem is that jobs is empty under SQL Server Agent. In SQL 2005 there is no problem because of the sqlagentreader role. Is it possible to let the user account just view or list jobs without being a sysadmin?

  /Niclas

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  June 12, 2008 at 9:21 am

  #827941

  Try granting EXECUTE permission on sp_help_job and maybe sp_get_composite_job_info in msdb.

  Greg

• Wildcat

  SSCarpal Tunnel

  Points: 4774

  More actions

  June 12, 2008 at 9:22 am

  #827943

  In msdb, there is a view "sysjobs_view". You can modify it to let others check the jobs. (Or, you can create one.)