September 27, 2002 at 10:53 am
I just read the following FAQ: "How can I know what task a DTS package is executing when a job starts the package?" The article is helpful but I have a job that is running which simply runs two queries, one right after the other, without any kind of logging code added to the DTS as suggested in the article. The first query has completed but the second query is still executing. Is there a way to tell when the first query finished before the job actually completes?
September 27, 2002 at 11:01 am
Yes, have the package log events at the step level to the event log...this will tell you exactly when one started and completed and the next step or task started...
hth,
Michael
Michael Weiss
Michael Weiss
September 27, 2002 at 11:31 am
Is this under the DTS Package Properties: Write completion status to Event Log? And where is the Event Log stored? How do I access this information?
Lastly, this was not turned on before I started the job -- is there a way to get at this information for a job that is currently executing?
September 27, 2002 at 11:40 am
Yes I believe it is the Write Completion Status to Event Log option. You can view this information via the Event Viewer under win2k through start/programs/administrative tools/event viwer...should be similar on winnt or winxp pro...and, no, you cant change this for jobs in progress...you have to wait until it completes I believe...
hth,
Michael
Michael Weiss
Michael Weiss
September 27, 2002 at 12:37 pm
So there's no other way to get at this information???
October 2, 2002 at 10:05 am
Run stored procedure master..sp_who or sp_who2
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply