sql query to find out maintenance plan name, schedule and action for sql server 2000/2005

• dbaing

  Valued Member

  Points: 54

  More actions

  August 19, 2010 at 10:30 pm

  #236841

  Hi Guys,

  Anyone have the query to perform the above?

  Not sure on which tables i can find out the schedule and action.

  thanks

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  August 20, 2010 at 1:40 pm

  #1209907

  Here they are

  SQL 2005

  ********

  sysdbmaintplan_databases

  sysdbmaintplan_history

  sysdbmaintplan_jobs

  sysdbmaintplans

  SQL 2000

  ********

  sysdbmaintplan_databases

  sysdbmaintplan_history

  sysdbmaintplan_jobs

  sysdbmaintplans

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  August 20, 2010 at 1:43 pm

  #1209910

  Searching this site you will probably find a few.

  MSSQLTips.com has tons of them down to translating the INIT data columns into what they actually mean.

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