EXEC msdb..sp_update_job @job_name = 'Job01', @enabled = 0;
USE msdb;
GO
DECLARE @job_name NVARCHAR(128);
DECLARE job_cursor CURSOR FOR
SELECT name
FROM msdb.dbo.sysjobs
WHERE enabled = 1
order by name;
OPEN job_cursor;
FETCH NEXT FROM job_cursor INTO @job_name;
WHILE @@FETCH_STATUS = 0
BEGIN
print 'EXEC msdb.dbo.sp_update_job @job_name = ''' + @job_name + ''', @enabled = 0;'
FETCH NEXT FROM job_cursor INTO @job_name;
END
CLOSE job_cursor;
DEALLOCATE job_cursor;
GO
use msdb
go
select 'EXEC msdb.dbo.sp_update_job @job_name = N' + CHAR(39) +
name + CHAR(39) + ' , @enabled = 0'
+ CHAR(10) + 'GO'
from sysjobs (NOLOCK) where enabled = 1
--Returns all jobs that are not idle or suspended
EXEC msdb.dbo.sp_help_job @execution_status=0
GO
Comments