View Single Post
  #1 (permalink)  
Old March 7th, 2011, 05:24 PM
brendenm brendenm is offline
Registered User
Join Date: Jun 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Question Long running package cancelled

Hey Jessica,

Everything about the framework is running great except one thing. Every so often i have a package or two that runs quite a bit longer than it's supposed to. I go into SQL Agent monitor and manually cancel the job. When i do this the logs within the framework database still treat the job as having a "running" status. I looked over some of the stored procedures for error handleing and was curious how i would account for a job that was cancelled by the user. As of right now, the LogPackageEnd only runs on success and if there is a way to account for this, i would think it would be there.

What i don't know is where to pull the information from and what to pull if a user cancelled a long running package. I think I could modify the procedure to log either "C" for cancelled or "S" for success but what information do i need to determine cancellation?

If it's not the LogPackageEnd, where would i put this new error handler? I don't recall there being a handler for that type of event.

Your help would be much appreciated.

Thanks, Brenden