Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
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





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





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