I have several jobs in SQL 2005 that I cannot delete. I get "The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id" the conflict occured in database "msdb", table "dbo.sysmaintplan_subplans" columd 'job_id'.
How can I fix this?
TIA <JP>
Hello my friend,
It looks like the job you are trying to delete is used in another job. Delete this other job and then it should let you delete it.
Kind regards
Scotty
|||
Scotty,
How do I identify other dependencies? I see nothing obvious poking me in the eye. I have several of these and can't figure it out. Could it be because I'm running in a cluster?
No comments:
Post a Comment