June 29, 2005 at 8:26 pm
Hi All,
I found out that one of my jobs (fired every 10 minutes) has a delay between the time it starts to run and the time the actual dts, it calls, executes.
Normally duration of the job doesn't take a second but it takes up to 37 to 45 minutes when this weird "delay" happens.
I found out that the delay was not in the dts itself because I placed traces inside the dts where it logs the time each task starts and finishes and there were never a lag time during this hanging period. Every tasks runs less than a second everytime.
What happened was the Job runs at 8:10pm (the job is to run the dts package) but according to the log dts only started running at 8:47pm (that was why the duration was 37 minutes)
But earlier and later Job runs every 10 minutes 24x7 with a duration of less than a second. This delay happens with no apparent time pattern, very intermittent.
The job is invoked by a dts package on a separate server machine, scheduled to run every 10 minutes. This job fails whenever the job on the other server hangs.
Any insights regarding this matter will be greately appreciated. Thank you very much for your time and I hope this never happens to you.
CountDigit
June 29, 2005 at 8:57 pm
Hi,
I had the same problem with backup of transaction log so i created a table in the system table and created a trigger when ever why job finished a log entry inserts in to the table and as the insert statement occurs my trigger fires and runs the job again.
later on i converted it on simple procedure due to overhead.
if this help u .
thanx
sufian
June 29, 2005 at 11:55 pm
Hello sufian,
The delay happens after the Start Run of the Job and the actual execution of the first task in the dts package (this dts package is the only step of the Job).
The delay/lag/hanging between these two events is what's bothering me and causes other dependent jobs to fail.
Thanks.
Countdigit
July 1, 2005 at 9:41 am
Could it be that you have locks in your system? That your DTS can't execute because it is waiting on locks to be released from important objects?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply