sql作业删除不了执行语句

select * from sysmaintplan_log
delete sysmaintplan_log

select * from sysmaintplan_subplans
delete sysmaintplan_subplans
USE [msdb]
DECLARE @job_name VARCHAR(100)
SET @job_name = N’数据备份.Subpaln_1′ —作业里的名字这里很关键

–注：jobName为维护计划对应的jobName
–删除在计划里面的日志
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