Home Forums SQL Server 7,2000 SQL Server Agent How can I disable a Job via TSQL RE: How can I disable a Job via TSQL

  • October 11, 2006 at 12:50 pm

    #665287

    It might be easier to use:

    exec msdb..sp_update_job @job_name = 'Job Name', @enabled = 0

    Paul (polecki@Insurance.com)