SQLServer2005的维护计划无法删除的解决方法
SQLServer2005的维护计划无法删除的解决方法
1.查看"维护计划"对象的ID
use msdb
select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans
use msdb
select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans
2.根据ID号删除相应的"维护计划"
use msdb
delete from sysmaintplan_log where plan_id = '0368F9BD-DF73-453F-9EE8-D48E7CEBCFBB'
delete from sysmaintplan_subplans where subplan_id = '51EA0AB6-805A-46FD-A8BD-63A9C94B8487'
delete from sysmaintplan_plans where id = '1CDC7884-C85E-436D-9C91-E767A3FCD81D'
delete from sysmaintplan_subplans where subplan_id = '51EA0AB6-805A-46FD-A8BD-63A9C94B8487'
delete from sysmaintplan_plans where id = '1CDC7884-C85E-436D-9C91-E767A3FCD81D'
目录 返回
首页