SSIS event handler when SQL Server Job stop the execution

• Zahran

  SSCommitted

  Points: 1724

  More actions

  May 8, 2012 at 1:42 am

  #255607

  I have a set of SSIS packages, which run on production server as SQL Server Jobs. I need to log the entry whenever SQL Server Job task cancelled the by user. Is there any event handler to catch the stop execution.

  - Zahran -

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  May 8, 2012 at 3:15 am

  #1484382

  As mentioned by Reza and me on the MSDN forum, there isn't an event handler that can achieve this.

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/db384aee-0041-46a2-b855-b60a74f6e0bd

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP