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
This is my first visit to your web journal! We are a group of volunteers and new activities in the same specialty. Website gave us helpful data to work. 여성유흥알바
ReplyDeleteI see the greatest contents on your blog and I extremely love reading them. job board
ReplyDeleteThank you very much for writing such an interesting article on this topic. as we provide Sales Recruitment Agencies at affordable prices. for more info visit our website.
ReplyDeleteGreat article, very useful and explanation. Your post is extremely incredible. as we provide jobs for people with disabilities at affordable prices. for more info visit our website.
ReplyDeleteI see the greatest contents on your blog and I extremely love reading them. termtechreview
ReplyDeleteReally nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing movies123
ReplyDeleteI was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more. https://www.giannasgrille.com/sarms-for-women/
ReplyDeleteReally nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing. romani in ukReally nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing. romani in uk
ReplyDelete