SQL2005的维护计划无法删除的解决方法
时间：2021-05-03 10:03:19|栏目：|点击： 次
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 = ' '
复制代码 代码如下:
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 = ' '
上一篇：驱除威胁―无线网络防黑完全攻略
栏 目：
下一篇：docker 容器上编译 go 程序提示找不到文件问题
本文地址：http://www.codeinn.net/misctech/114017.html
