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
Last modified: March 20, 2025

Author

Comments

Write a Reply or Comment