Can't remove job 1

[vba317]

I am running SQL 2005. I am trying to remove a job with no success. I have tried to right click on the job and click on delete and I get the error Drop failed for job and job name. The delete statement conflicted with the reference constraint "FK_subplan_job_id" The conflict happened in database msdb,table "dbo.sysmaintplan_subplans,column job_id".
Any help is appreciated

 

[gmmastros]

try this:

http://dbamohsin.wordpress.com/2011...h-the-reference-constraint-fk_subplan_job_id/

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom