Monday, April 16, 2012

Jobs with SSIS package and location

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

No comments:

Post a Comment