USE [msdb]DECLARE @job_name VARCHAR(100)SET @job_name = N‘JobName‘--注：jobName为维护计划对应的jobName--删除在计划里面的日志DELETE    sysmaintplan_logFROM    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_idWHERE    (syjobs.name = @job_name)--删除代理的作业DELETE    sysjobschedules FROM sysjobs_view v    INNER JOIN sysjobschedules o ON v.job_id=o.job_idWHERE    v.name=@job_name--删除子计划DELETE    sysmaintplan_subplansFROM    sysmaintplan_subplans AS subplans        INNER JOIN sysjobs_view AS syjobs ON subplans.job_id = syjobs.job_idWHERE    (syjobs.name = @job_name)--删除作业DELETE FROM msdb.dbo.sysjobs_view WHERE name = @job_name