countdigit
Programmer
Hi All,
I found out that one of my jobs (scheduled to run every 10 minutes) has a delay between the time it starts to run and the time the actuals 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
I found out that one of my jobs (scheduled to run every 10 minutes) has a delay between the time it starts to run and the time the actuals 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