|
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
Navigation:
[Reply to this message]
|