Skip to content

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

Published inSQL

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

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