looking for a T-SQL query to find names of ssis packages scheduled via Agent that that execute a specific stored procedure

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  August 23, 2018 at 2:12 pm

  #408302

  Is it possible to find out names of SSIS packages scheduled via Agent that that execute a specific stored procedure by Stored Procedure name?

  Likes to play Chess

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 23, 2018 at 2:23 pm

  #2003109

  Please do not double post.  It can fragment answers.
  Please post answers here: https://www.sqlservercentral.com/Forums/1991338/Is-it-possible-to-retrieve-names-of-SSIS-packages-that-have-an-Exec-SQL-task-that-executes-a-specifi