What privilege I need to see maintenance job in sql 2005?

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  June 1, 2010 at 11:39 am

  #235874

  I have an id, it's dbowner for a database, but the id can't see the maintenance job, I guess the maintenance job is on server level? what's the privilege I should ask in order to see or have full control on the maintenance job - I thought it is part of the database.

  Thanks.

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  June 1, 2010 at 12:37 pm

  #1174965

  http://msdn.microsoft.com/en-us/library/ms187658(v=SQL.90).aspx

  You must be a part of sysadmin fixed-server role.

  *OR*

  You can try to give the account SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed database role, but this path will give the account access to all jobs.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• halifaxdal

  SSCoach

  Points: 19741

  More actions

  June 1, 2010 at 8:19 pm

  #1175067

  Thank you.