SQL SERVER 2005刪除維護作業報錯：The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_jo

標籤：

下面是網上找的一些資料來解決這個問題：
先擷取這個job_id:

USE [msdb]GO/****** Object:  Job [dbbackup_diff.Subplan_1]    Script Date: 04/08/2015 10:22:46 ******/EXEC msdb.dbo.sp_delete_job @job_id=N‘588acfb8-630b-41c3-aa47-90d3671bda90‘, @delete_unused_schedule=1GO

根據job_id到subplan_id:

select subplan_id FROM msdb.dbo.sysmaintplan_subplans where job_id=‘588acfb8-630b-41c3-aa47-90d3671bda90‘subplan_idFE56B397-4704-4AA7-BE49-767C1574E7D0

從系統資料表msdb.dbo.sysmaintplan_log和msdb.dbo.sysmaintplan_subplans中分別刪除subplan_id為‘FE56B397-4704-4AA7-BE49-767C1574E7D0’的記錄：

delete from msdb.dbo.sysmaintplan_log where subplan_id=‘FE56B397-4704-4AA7-BE49-767C1574E7D0‘

delete FROM msdb.dbo.sysmaintplan_subplans WHERE SUBPLAN_ID=‘FE56B397-4704-4AA7-BE49-767C1574E7D0‘

再次回到圖形介面再刪除job就不會報錯了。

參考：
http://www.cnblogs.com/kerrycode/p/3852231.html

SQL SERVER 2005刪除維護作業報錯：The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_jo