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