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
