—以下代码在查询分析器中执行---------------------------------
1、删除维护计划
use msdb
go
select * from sysmaintplan_plans
Delete sysmaintplan_plans where Name=‘要删除的计划名称’
2、删除代理中的作业
USE [msdb]
Declare @job_name varchar(100)
–SET @job_name = N’jobName’
SET @job_name=N’要删除的作业名称’
–注:jobName为维护计划对应的jobName
–删除在计划里面的日志
DELETE sysmaintplan_log
FROM sysmaintplan_subplans as subplans
INNER JOIN sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
INNER JOIN sysmaintplan_log on subplans.subplan_id =sysmaintplan_log.subplan_id
WHERE (syjobs.name = @job_name)
–删除代理的作业
DELETE sysjobschedules
FROM sysjobs_view v
INNER JOIN sysjobschedules o on v.job_id=o.job_id
WHERE v.name=@job_name
–删除子计划
DELETE sysmaintplan_subplans
FROM sysmaintplan_subplans as subplans
INNER JOIN sysjobs_view as syjobs ON subplans.job_id = syjobs.job_id
WHERE (syjobs.name = @job_name)
–删除作业
DELETE FROM msdb.dbo.sysjobs_view WHERE name = @job_name
—创建新的维护计划时出错解决方案---------------------------------
1、生成备份的目标文件夹增加everyone用户赋予修改权限
2、C:\Windows\Temp 文件夹增加everyone用户赋予修改权限
3、如果新建维护计划不行并报错误代码 OLE DB 错误代码0x80004005,有的是“通讯链路连接失败”
处理方法:点中服务器实例->属性–》高级–》网络数据包大小,把这个数改小就行了。