Disabling and Enabling All SQL Server Agent Jobs

Disabling and Enabling All SQL Server Agent Jobs

As part of a recent Microsoft SQL Server migration project I had a need to disabled and enable all of the Agent Jobs as various points, the below scripts did the job. This scripts have been tested on SQL 2005 to 2012

Disable All Jobs

USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO

Enable All Jobs

USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 1
WHERE Enabled = 0;
GO

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.