解决 SQLSERVER 2008 无法删除作业

USE [msdb]

DECLARE @job_name VARCHAR(100)

SET @job_name = ?N'syspolicy_purge_history'

--注：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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!