Script to get SSIS Jobs

Script to get SSIS Jobs.

This script will help you out to get Job Details by category like SSIS,TSQL,etc..


USE MSDB

GO

SELECT Sj.Job_id   AS Jobid,
       Sj.Name     AS Jobname,
       Sjs.Command AS Command
FROM   Sysjobs Sj
       INNER JOIN Sysjobsteps Sjs
               ON( Sj.Job_id = Sjs.Job_id )
WHERE  Sjs.Subsystem = 'SSIS'-- other types (LogReader,PowerShell,Snapshot,TSQL)
       AND Sj.Enabled = 1

GO 

Script to get SSIS Jobs

 

Regards,

Nirav Gajjar