You are here:Home » SSIS » Find SSIS package details scheduled in jobs - SQL Server

Find SSIS package details scheduled in jobs - SQL Server

I would like to share the script to find out the scheduled jobs which call SSIS packages in SQL Server.
USE MSDB
GO
SELECT 
 sj.job_id as JobId,
 sj.name as JobName,
 sjs.step_name as StepName,
 sjs.Command as Command
FROM sysjobs sj 
INNER JOIN sysjobsteps sjs
 ON(sj.job_id = sjs.job_id)
 WHERE sjs.subsystem = 'SSIS'
GO
The script return job name and the SSIS package full path as a command like "/FILE " here SSIS package full path" /CHECKPOINTING OFF /REPORTING E"