返回
-
标题
How to disable a job by tsql script -
说明
How to disable a job prior to running another task, without deleting the job? -
解决办法
WORKAROUND:
SQL Server jobs can be disabled via Enterprise Manager or SSMS GUI screens or the job can be disabled by jobid or job_name in msdb
Example:
EXEC msdb.dbo.sp_update_job @job_name='Your job name',@enabled = 0 -
其他信息
For additional, see: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3957756&SiteID=1