Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
This is the forum to discuss the Wrox book Microsoft SQL Server 2008 Integration Services Problem-Design-Solution by Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney ; ISBN: 978-0-470-52576-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 7th, 2011, 05:24 PM
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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SSIS Package Retrieving and Running John2112 SQL Server DTS 2 March 10th, 2010 07:48 AM
Running stand alone DTS package Dhodie SQL Server DTS 0 September 5th, 2005 02:23 AM
Running DTS package from withing a stored proc flaco SQL Server DTS 2 July 27th, 2004 05:34 PM
Running and pausing exe's from DTS Package leehambly SQL Server DTS 2 September 22nd, 2003 10:15 AM
long running backup schedule prakashvj SQL Server 2000 1 June 9th, 2003 10:07 AM

All times are GMT -4. The time now is 05:59 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.