Server 2008 Scheduled Task - Access Macro suddenly time out
Posted on 2013-12-03
I run 5 scheduled tasks consecutively each hour on my server 2008. Each task calls a different Access 2007 DB and runs a series of macros to summarize data.
Everything has worked fine until about 1.5 weeks ago when one task (the main one) started timing out due to reaching a 23 minute time limit that I imposed. When I run the task manually "Run only when user is logged on" it runs perfectly in 9 minutes every time, but when it runs on schedule (or when I run it on command) using "Run whether user is logged on or not" it times out after 23 minutes and is terminated.
I thought it was obviously a permission thing, but after trying everything I can think of, I still cannot get it to run. I have changed the user/group to other administrators, SYSTEM but it still terminates at 23 min. Strange thing is the other 4 tasks use the same administrator (LVAPPS\administrator) and run fine, but his one will not.
I have also checked the permission of each access db and the folders they sit in ... all are identical and have full permissions for LVAPPS\administrator.
I have deleted and recreated the task several time ... no luck ... out of ideas ...
Anyone recognize this?