Tuesday, March 8, 2016

Disable or Enable all SQL Agent Jobs




declare @sql nvarchar(max) = '';
select
@sql += N'exec msdb.dbo.sp_update_job @job_name = ''' + name + N''', @enabled = 0;
' from msdb.dbo.sysjobs
where enabled = 1  --1= Enabled, 0 is disabled
order by name;

print @sql;
--exec (@sql);

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...