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
Good Viki...
ReplyDelete