Skip to content

Instantly share code, notes, and snippets.

@LetsGoRafting

LetsGoRafting/SSIS Job Step commands

Created June 8, 2022 00:24
Show Gist options
  • Save LetsGoRafting/b21bcbf60f8b1edbd930a573da2aa6ca to your computer and use it in GitHub Desktop.
Save LetsGoRafting/b21bcbf60f8b1edbd930a573da2aa6ca to your computer and use it in GitHub Desktop.
Download ZIP
SSIS Job Step commands
Raw
SSIS Job Step commands
use msdb
select [job]=j.name, [step]=s.step_name, s.command
from dbo.sysjobsteps s
inner join dbo.sysjobs j
on s.job_id = j.job_id
and s.subsystem ='SSIS'
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment