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