首页 > SQL Server 2005的维护计划无法删除的解决方法

SQL Server 2005的维护计划无法删除的解决方法

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推荐
SQL Server 2005/2008...
SQL Server CROSS APP...
SQL Server 2005中查询用分...
SQL查询日志、查看数据库历史查询记录的...
创建SQL Server 2005计划任...
SQL Server巧用row_numb...