Database Maintenance Plan and Jobs Link

• HookSQLDBA7

  SSChampion

  Points: 10555

  More actions

  November 30, 2004 at 2:14 pm

  #91543

  I created a Database Maintenance Plan and scheduled it. This created a Maintenance Plan Job. I went back to the Database Maintenance Plan and renamed it. Does this action affect the Maintnenance Plan Job in any way? I am not sure but I do not think so since it seems like in the Job Step the Plan is linked to the Job via the PlanID. Also, what tables may I join and select on to see which PlanID is linked to which Job?

  Thanks in advance, Kevin

   

• December 3, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Jimmy Jen

  SSCrazy

  Points: 2915

  More actions

  December 3, 2004 at 8:15 am

  #532462

  Changing the plan name will not affect the job because Sysdbmaintplans table uses Plan_id as pk and not plan name.

  You can join Sysdbmaintplans to Sysdbmaintplan_jobs to get job_id, and if you want to know the job name then you also need to join to Sysjobs.