SQL2005的維護計劃無法刪除的解決方法

今天開發(fā)中,發(fā)現(xiàn)維護計劃無法刪除刪除了,遂發(fā)現(xiàn)下面的代碼,希望對碰到類似問題的朋友有所幫助。

1.查看”維護計劃”對象的ID
代碼如下:
use msdb

select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans

2.根據(jù)ID號刪除相應(yīng)的”維護計劃”
代碼如下:
delete from sysmaintplan_log where plan_id = ‘ ‘
delete from sysmaintplan_subplans where subplan_id = ‘ ‘
delete from sysmaintplan_plans where id = ‘ ‘

? 版權(quán)聲明
THE END
喜歡就支持一下吧
點贊9 分享