September 23, 2002 at 10:16 am
Hello,
I have SQLServer7.0 on Win2K platform.
When I'm running a manual process from one DTS package a job scheduled to run from another DTS package should fail (and it used to fail before).
Now for some reasons it stays in 'Executing...' mode and never stops.
This is the end of my Function Main() for the scheduled DTS package:
*********************************************
ELSEIF CheckSystemProcessRunning = 1 Then
pkg_errors = 1
MsgBox "Another Instance of 'LUPD' process running."
END IF
IF pkg_errors = 0 THEN
Main = DTSTaskExecResult_Success
ELSE
Main = DTSTaskExecResult_Failure
END IF
********************************************
Where CheckSystemProcessRunning function is equal 1 when a manual process is running.
I had this problem long ago with another set of packages and I used the advise which I received from SQLServerCentral forum to uncheck the 'Explicit Global Variables' check box in the 'Global Variables' tab of the package properties and it worked. But now this advise doesn't work for my new packages.
I recreated both packages on the Server machine and run a package and a job on the same Server. Didn't help.
But if I'm running both packages manually a scheduled package fails (as it should).
Could anybody help me with this issue?
September 23, 2002 at 10:37 am
The msgbox is hanging a scheduled job. Remove it and see if that fixes it.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 23, 2002 at 10:48 am
Steve,
You are a genius. Thank you so much.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply