Need Role to Manage Jobs

• d33m

  SSChasing Mays

  Points: 620

  More actions

  November 20, 2008 at 11:46 am

  #96772

  I need to create a role to manage the jobs: view, start, stop, add job/step, delete job/step, etc, without giving the role sa privileges. I've tried to create a role and give it dbo on the msdb database but that doesn't do the trick. I am not able to view the jobs through enterprise manager even with dbo on the msdb database.

  Any help is appreciated.

  Thank you

• d33m

  SSChasing Mays

  Points: 620

  More actions

  November 20, 2008 at 12:14 pm

  #901232

  From my understanding that role only exists in 2005 along with SQLAgentUserRole and SQLAgentReaderRole. I need this role for 2000.