批量置Job为无效

使用系统存储过程EXEC dbo.sp_update_job[@more@]

EXEC dbo.sp_update_job
@job_name = N'NightlyBackups',
@new_name = N'NightlyBackups -- Disabled',
@description = N'Nightly backups disabled during server migration.',
@enabled = 0

select name, enabled, 'EXEC dbo.sp_update_job @job_name = N''' + name + ''', @enabled = 0' from msdb.dbo.sysjobs
where name not in('')

请使用浏览器的分享功能分享到微信等