Most of the DBA’s might have came across a situation where they want to disable all SQL jobs for DR environments or test environments.Below script does this for you and is really handy on servers where there are many jobs:-
USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO