The below code can be used to find out all the SQL Server Agent Job Steps which use SSIS Package.
USE [msdb] GO
SELECT Srv.srvname AS ServerName, 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
JOIN MASTER.dbo.sysservers Srv ON Srv.srvid = Job.originating_server_id
WHERE JStep.subsystem='SSIS'
ORDER BY Job.name,step_id
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.