删除作业计划出错(DELETE语句与 REFERENCE约束＂FK_subplan_job_id＂冲突。)
删除作业计划出错(DELETE语句与 REFERENCE约束＂FK_subplan_job_id＂冲突。)
use msdb select * from sysmaintplan_plans --查看作业ID delete from dbo.sysmaintplan_log where plan_id = 'B07A0E52-6163-4370-A58C-2E745CB16E39' delete from sysmaintplan_subplans where plan_id = 'B07A0E52-6163-4370-A58C-2E745CB16E39' DELETE FROM sysmaintplan_plans WHERE [ID]= 'B07A0E52-6163-4370-A58C-2E745CB16E39' --然后再到SQL SERVER 代理-----作业----即可删除
