Tag Archives: Enable SQL Job

How to Enable multiple SQL agent Jobs using single SQL Query

Here is the SQL query to Enable multiple SQL Agents Jobs. exec sp_configure ‘allow updates’,1 go reconfigure with override go update msdb.dbo.sysjobs set [enabled] = 1 where name like ‘Ownership Standardization%’ go exec sp_configure ‘allow updates’,0 go reconfigure with override … Continue reading

Posted in Advanced SQL | Tagged , , , | Leave a comment