SQLServer2005的维护计划无法删除的解决方法 |
| 发表者：分类：数据库2014-03-27 18:06:53 阅读[2775] |
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'
转载请标明出处【SQLServer2005的维护计划无法删除的解决方法】。
《www.micoder.cc》
虚拟化云计算,系统运维,安全技术服务.
| Tags： | [阅读全文...] |
最新评论