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
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.