Listing maintenance plans for an entire instance

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  January 7, 2008 at 2:17 pm

  #181916

  I know I've seen it before but I can't find it!!!!! Does anyone know what query will give a list of Maintenance Plan schedules?????

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  January 15, 2008 at 8:20 am

  #768163

  I believe you would like to find jobs.

  You can go to the msdb..sysjobs to find it.

  SELECT DISTINCT name from msdb..sysjobs

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 15, 2008 at 8:35 am

  #768179

  select * From sysschedules

  Goes for all jobs. Maintenance plans are jobs.