.MDB as scheduled task runs slow

[mcccna]

I have an access program which will complete in about 4 hours if executed. If run as a scheduled task it times out after 12 hours. It is processing during that time, but it doesn't complete. It is a routine which must run nightly and complete before start of business. I'm using Access 2003 and running it on Win2k server. The machine is new with monster hardware, so that isn't the problem.

Thanks!
Dave

 

[lupins46]

Check the Idle Time settings in the Scheduled task properties. (Stop this task....)

 

[mcccna]

I realize I could change the time out period and let the task complete, but my problem is that it runs too slow. I need it to complete over night as it updates records which will be used the next day. As a scheduled task it is taking many time longer to complete than if ran by simply clicking the icon.

 

[lupins46]

So have you checked the idle time settings?

 

[mcccna]

I appologize, I didn't pay very close attention. There are no idle time settings on this task. Neither of the 2 boxes are checked.

 

[lupins46]

Oh well - it was a possibility.
I don't know enough to see how Windows prioritises scheduled jobs but I imagine it must be something to do with the amount of time it's getting.

 

[PHV]

I have an access program which will complete in about 4 hours
Ouch...
No way to optimise it ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244