1.获取作业的ID
USE [msdb]
declare @job_id uniqueidentifier
declare @schedule_id int
SELECT @job_id = @job_id FROM dbo.sysjobs where name ='YourJobName'
2.获取计划ID
set @schedule_id = (select top 1 schedule_id from dbo.sysjobschedules where job_id = @job_id)
3.获取修改的SQL语句,并修改
4.最终
USE [msdb]
declare @job_id uniqueidentifier
declare @schedule_id int
SELECT