SSIS jobs activities

• Shaun2012

  Hall of Fame

  Points: 3214

  More actions

  November 5, 2013 at 9:05 am

  #300746

  Hi All,

  I want to write small query, which can show me alll the SSIS jobs activities

  Shuan

• sestell1

  SSChampion

  Points: 10230

  More actions

  November 5, 2013 at 12:07 pm

  #1664217

  Are you looking for a query that will list all of the scheduled jobs that contain an SSIS step?

  SELECT

  Job.Name AS Job_Name,

  Step.Step_ID AS Step_Number,

  Step.Step_Name,

  Step.Command AS Step_Command

  FROM

  MSDB.dbo.SysJobs Job

  JOIN

  MSDB.dbo.SysJobSteps Step

  ON

  Job.Job_ID = Step.Job_ID

  WHERE

  Step.SubSystem = 'SSIS'