wallstreetsqlserverdba
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment