dbTalk Databases Forums  

Reliably stopping a package that has been loaded and run programmatically.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Reliably stopping a package that has been loaded and run programmatically. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lee Gillie
 
Posts: n/a

Default Reliably stopping a package that has been loaded and run programmatically. - 08-27-2004 , 03:00 PM






As part of an extended protection, I want to reliably stop a package's
execution, programmatically, if it is taking too long, due to a problem.

I see the OnQueryCancel event provided, which is intended for this, and
have logged it a bit, to see what it does. It does not seem to fire
while ActiveX scripts are running. My guess is that it MIGHT not fire
during a deadlock scenario either?

In trying to protect against infinite loops in script, and deadlocks, my
fear is that the OnQueryCancel event may never fire when I need it most,
and so, may not be reliable for the recovery scenarios I am attempting.

Seeking the wisdom of others who have already considered or worked with
this.

Should I be trying to additionally do something more abortive if the
OnQueryCancel event does not fire within a minute or two?

Not exactly sure what that might be, other than causing my Windows
Service, which has loaded and run the DTS, to exit/stop. Maybe there is
some trick to shut down package execution more abortively?

Best regards - Lee Gillie


Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.