When one of posters asked a question about this, someone posted the following reply UPDATE msdb.dbo.sysjobs SET enabled = 0 As sysjobs is a system and updating it is generally not advised, the following can be used instead declare @sql varchar(max) set @sql='' select @sql=@sql+' EXEC msdb...