SQL2005的维护计划无法删除的解决方法

前端之家收集整理的这篇文章主要介绍了SQL2005的维护计划无法删除的解决方法前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

1.查看"维护计划"对象的ID


代码如下:
use msdb select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans

2.根据ID号删除相应的"维护计划"


代码如下:
delete from sysmaintplan_log where plan_id = ' ‘
delete from sysmaintplan_subplans where subplan_id = ' '
delete from sysmaintplan_plans where id = ' '

猜你在找的MsSQL相关文章