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)
1,128 times
Add to favorites
Databases
9/5/2012
E-mail Twitter del.icio.us Digg Facebook