SQL SERVER 代理作业无法删除的解决方法

USE [msdb]
declare @job_name varchar(100)
set @job_name ='ECD438BF-E424-4E60-BC12-FD5A1FB0DF78'

--删除在计划里面的日志

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.job_id = @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.job_id = @job_name)

--删除作业,也可以直接在Mangement Studio里面直接删除

delete
from msdb.dbo.sysjobs_view where job_id = @job_name