Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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
