Listing Enabled SQL Agent Jobs Executing SSIS Packages

This script loops through all enabled jobs of a specified SQL Server Agent, and lists all of their steps which call SSIS packages.Please don't forget to set the value of the $ServerName variable - otherwise the script tries to run on localhost.If you would like to check all jobs

4 Star
1,128 times
Add to favorites
E-mail Twitter Digg Facebook