Hi,

I have a situation where I had created a maintenance plan and edited the
resulting job. I had to delete the maintenance plan and job. In SQL2000 I
would delete the job first then the maintenance plan. I tried this is
SQL2005 and had errors. It referred to the DELETE statement conflicted with
REFERENCE constraint "FK_subplan_job_id". The conflict occurred in msdb
table dbo.sysmaintplan_subplans", column 'job_id'.

I could not delete the maintenance plan either. In the end I renamed the job
then I could delete the maintenance plan.

This is on SQL2005 SP1.

Thanks

Chris

I have same problem.  Did you ever get a reply?  If so, what do I do?  I have
several orphan jobs I cannot delete.  Thanks for any info.

DaveK,

I mentioned in my post how I fixed this. Nobody else replied.

Chris

Show quoteHide quote

Little Lock Symbols
lost sa password due to loss of employee
Backup using the proxy account in SQL2005
Copy Sql Studio Output to Outlook in HTML? Grids to Excel? What gi
Scripting db creation