skip to main | skip to sidebar

Sql Server Tuning for Dummies

Saturday, December 7, 2013

Disable Multiple SQL Jobs at once

http://sqlwithmanoj.wordpress.com/2013/04/09/disableenable-multiple-sql-jobs-at-once/

USE msdb;
GO

-- Disable Multiple SQL Jobs at once:
DECLARE @dynSql NVARCHAR(MAX) = ''

SELECT @dynSql += N'exec msdb.dbo.sp_update_job @job_name = ''' + name + N''', @enabled = 0;' + CHAR(10) + CHAR(13)
FROM msdb.dbo.sysjobs
WHERE enabled = 1
ORDER BY name;

PRINT @dynSql;
Posted by joe at 1:04 PM No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2019 (1)
    • ►  March (1)
  • ►  2017 (2)
    • ►  May (1)
    • ►  April (1)
  • ►  2016 (6)
    • ►  September (1)
    • ►  May (2)
    • ►  April (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2015 (11)
    • ►  September (1)
    • ►  August (1)
    • ►  July (3)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (2)
  • ►  2014 (6)
    • ►  November (1)
    • ►  October (1)
    • ►  March (2)
    • ►  January (2)
  • ▼  2013 (16)
    • ▼  December (1)
      • Disable Multiple SQL Jobs at once
    • ►  October (1)
    • ►  September (3)
    • ►  August (5)
    • ►  June (1)
    • ►  April (1)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (13)
    • ►  December (3)
    • ►  October (1)
    • ►  September (3)
    • ►  August (4)
    • ►  April (2)

About Me

joe
View my complete profile