NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > msdb > Set Include step in output history

Template Script: msdb\Set Include step in output history.sql

SELECT  j.name,
        flags | 32 AS NewFlag,
        js.*
-- UPDATE js SET flags = flags | 32
FROM    msdb.dbo.sysjobsteps js
INNER JOIN msdb.dbo.sysjobs j ON j.job_id = js.job_id
WHERE   flags & 32 = 0
        AND subsystem IN ('CmdExec', 'SSIS')

SELECT  j.name,
        flags | 4 AS NewFlag,
        js.*
-- UPDATE js SET flags = flags | 4
FROM    msdb.dbo.sysjobsteps js
INNER JOIN msdb.dbo.sysjobs j ON j.job_id = js.job_id
WHERE   flags & 4 = 0
        AND subsystem = 'TSQL'

Description for Template Script: msdb\Set Include step in output history.sql

Todo