2005191535@SQL禁用所有作业 | LOFT.CLUEE.TECH

use msdb
go
 
declare @sql nvarchar(4000)
set @sql=''
 
while exists(select top 1 1 from dbo.sysjobs where enabled=1)
begin
 
select top 1 @sql='EXEC dbo.sp_update_job @job_name = N'''+name+''',@enabled = 0;' from dbo.sysjobs
where enabled=1
 
--print @sql
exec(@sql)
end