Posted by Razvan Socol on 12/19/05 20:53

Hi, Diane

Try the following:

USE msdb
SELECT plan_name FROM sysdbmaintplans p
INNER JOIN sysdbmaintplan_jobs pj ON p.plan_id=pj.plan_id
WHERE job_id NOT IN (SELECT job_id FROM sysjobs)

If you get any result from this query, delete and recreate the
specified DB Maintenance Plans.

Razvan

[Back to original message]