View Jobs without SysAdmin Privilege

• cooljogging

  Grasshopper

  Points: 23

  More actions

  November 14, 2001 at 3:39 am

  #57520

  Is there any way that a non 'sa' users can view and

  edit jobs in SQL2000??

  thanks,

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736627

  More actions

  November 14, 2001 at 9:43 am

  #420087

  Don't think so, but I will take a look.

  Steve Jones

  steve@dkranch.net

• SQLZ

  SSChampion

  Points: 12872

  More actions

  November 15, 2001 at 4:32 am

  #420116

  There is a built in role in the msdb database called TargetServersRole that allows any users within the role to execute sql server jobs.

  I'm not sure whether it allows users to edit jobs but it might be worth trying.

  Karl Grambow

  Karl
  source control for SQL Server