你可以利用语句来完成
update msdb.dbo.sysjobs set enabled = 1 where job_id =
( select job_id from msdb.dbo.sysjobs where (name = N'任务名称'))
update msdb.dbo.sysjobs set enabled = 1 where job_id =
( select job_id from msdb.dbo.sysjobs where (name = N'任务名称'))
set enabled=0
from sysjobschedules a join sysjobs b on a.job_id =b.job_id
where b.name='backup-monthly'enabled 调度的启用状态
1--启用 0--将禁用该作业中的所有步骤