解決 SQLSERVER 2008 無法刪除作業

標籤：style   blog   http   ar   color   sp   on   div   2014   

SQLSERVER 2008 中刪除作業時遇到無法刪除

解決辦法：

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

 

解決 SQLSERVER 2008 無法刪除作業