Saturday, 14 June 2014

Query to findout SQL Agent Jobs which uses SSIS packages



Following Query is used to get the list of SQL Agent Jobs which call SSIS packages from
them



USE [msdb]
GO


SELECT
      Job.name AS JobName,
      JStep.step_id,
      JStep.step_name AS StepName,
      JStep.command,
      Job.enabled
FROM   dbo.sysjobs Job
JOIN   dbo.sysjobsteps JStep
      ON  JStep.job_id = Job.job_id
WHERE  JStep.subsystem='SSIS'
      ORDER BY Job.name,step_id

No comments:

Post a Comment