July 19, 2012 at 4:57 pm
Hello All,
Please help me in fixing this issue:
When I tried to delete a job, I got the below error:
Drop failed for Job 'Job Name'
The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb:, table "dbo.sysmaintplan_subplans", column 'job_id'.
Thanks in Advance !!!
July 21, 2012 at 7:51 am
If its a job linked to a Maintenance Plan are yountrying to delete the job from SQL Agent directly, or within the Maintenance Plan in the 'scheduling' section?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 21, 2012 at 10:02 am
looks like this is a known issue.
Please take a look at the URL(s) mentioned below for additional details:
http://sqlrx.wordpress.com/2011/07/13/remove-maintenance-plans-left-after-a-server-rename/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply