SSIS - How To Find The SQL Server Agent Job Names and Steps Where SSIS Package Is Used

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

19 comments:

  1. 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. 여성유흥알바

    ReplyDelete
  2. I see the greatest contents on your blog and I extremely love reading them. job board

    ReplyDelete
  3. Thank 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.

    ReplyDelete
  4. Great 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.

    ReplyDelete
  5. I see the greatest contents on your blog and I extremely love reading them. termtechreview

    ReplyDelete
  6. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing movies123

    ReplyDelete
  7. I 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/

    ReplyDelete
  8. Really 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
  9. It proved to be Very helpful to me and I am sure to all the commentators here! click here

    ReplyDelete
  10. Your site is truly cool and this is an extraordinary moving article. good morning messages for him

    ReplyDelete
  11. Decent information picking up article. This post is truly the best on this profitable subject. Unique Dofollow Backlinks

    ReplyDelete
  12. Well, this got me thinking what other workouts are good for those of us who find ourselves on the road or have limited equipment options. Blog Comments

    ReplyDelete
  13. The worst part of it was that the software only worked intermittently and the data was not accurate. You obviously canot confront anyone about what you have discovered if the information is not right. Unique Dofollow Backlinks

    ReplyDelete
  14. Thanks for making this blog helpful for me! I am doing online SQL Server Career Training and I would like to thank for the efforts you have made in writing this post. Thanks for sharing

    ReplyDelete
  15. Hi, Thank you for this informative blog, I have just started to SQL‌ Server‌ Career Training Training and Certification and this blog is definitely very helpful for me. Thank you for this informative blog.

    ReplyDelete
  16. The information you've provided is useful because it provides a wealth of knowledge that will be highly beneficial to me. Thanks you for sharing. Keep up the good work. Job Recruiting Agency in Usa.

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. The world of pet reptiles is diverse, from slow-moving turtles to quick-witted chameleons. They offer a glimpse into the Animal hospitalc incredible diversity of the animal kingdom.

    ReplyDelete