Skip to content

Month: September 2020

Disable and Enable SQL Jobs

Quick to disable and enable all SQL jobs on your server

USE MSDB

-- DISABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1

-- ENABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 1
WHERE Enabled = 0

You already voted!
Leave a Comment