今天開發(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)聲明
文章版權(quán)歸作者所有,未經(jīng)允許請勿轉(zhuǎn)載。
THE END