处理SQLServer作业无法删除的问题

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

use [msdb]    declare @job_name varchar(100)    set @job_name = N'正式库每天凌晨3:00第二次完整备份.Subplan_1'    --注：job_name为维护计划对应的job name    --删除在计划里面的日志    delete sysmaintplan_log from sysmaintplan_subplans as subplans    inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id    inner join sysmaintplan_log on subplans.subplan_id =sysmaintplan_log.subplan_id    where (syjobs.name = @job_name)    --删除代理的作业    delete sysjobschedules from sysjobs_view v    inner join sysjobschedules o on v.job_id=o.job_id where v.name=@job_name    --删除子计划    delete sysmaintplan_subplans from sysmaintplan_subplans as subplans    inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id    where (syjobs.name = @job_name)    --删除作业    delete from msdb.dbo.sysjobs_view where name = @job_name       --查询有哪些作业 select * from msdb.dbo.sysjobs_view

　　错误现象：delete  语句与 reference 约束"FK_subplan_job_id"冲突。该冲突发生于数据库"msdb"，表"dbo.sysmaintplan_subplans", column 'job_id'。语句已终止。 (Microsoft SQL Server，错误: 547)