SQL 2005删除作业计划出错(DELETE语句与 REFERENCE约束"FK_subplan_job_id"冲突。)的解决...

打开SQL查询，

use msdn

delete from sysmaintplan_SubPlans where SubPlan_Name='子计划'

delete from SysSchedules whrere name='作业名'

然后再到SQL SERVER 代理-----作业----即可删除

转载于:https://blog.51cto.com/roboboy/482895