Created
May 5, 2016 16:01
-
-
Save kristinaconley/d4448457b4b3f155158969c806ba9596 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment