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

  • August 16, 2011 at 11:46 am

    #1369229

    SELECT job_id,[name] FROM msdb.dbo.sysjobs

    EXEC msdb.dbo.SP_UPDATE_JOB @job_id = 'B9D5575F-56FB-4B34-8180-2728FB70BC0F' , @enabled =1