Find SSIS in jobs
List all ssis packages in any job.
Last updated:
Warning: Review and test in a non-production environment before running.
Use msdb;
SELECT sysjobs.name AS 'JobName', sysjobsteps.step_id AS 'Step#', sysjobsteps.command AS 'SSISLocation'
FROM sysjobs INNER JOIN sysjobsteps
ON sysjobs.job_id = sysjobsteps.job_id
where subsystem='ssis'
order by 1