Scheduled tasks are not completing

I have Windows XP Prof. SP2 and have used the scheduled task utility to open a MS access based utility/application every morning at a set time. The Access utility has some VBA code that processes some data and then generates some reports. The problem is that the utility never completes running all the processes. I decided to split the tasks into three modules and run 3 utilities together but still none of the three completes the processes.
If I run the process manually everything runs successfully without any problems. Does anyone know how to resolve this issue? I appreciate all your help.
ofafa72Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NicolasQuenardCommented:
Go into the Scheduled Tasks, then click on Advanced, and finally click on View Log. You will find in this log file details about what went wrong.
The error code you will find are not error code of the Scheduled but of of your scripts.
You should try to run the tasks in command line with the command runas with you execute the task with a particular user.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
When you say you "split this into 3 modules", do you mean 3 separate code modules in the same database?

Do the code modules depend on each other? That is, does Module1 have to complete before Module 2 runs?

How are you firing the modules? Are you using a Startup form?
0
ofafa72Author Commented:
The three modules are independent of each other and yes I am using a start up form to fire them.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

ofafa72Author Commented:
NicolasQuenard,

Manually all the three tasks take about 90 minutes to run. I have configured the scheduler to stop after 180 minutes. I didn't find any other errors other than what's below.
** WARNING **
The task was forced to close since its execution time exceeded the configured maximum.

How do I run tasks in command line?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you running these at the same time? Or do you run the first, then the second, then the third? Are there any other processes running that could cause a conflict (like a virus scan or backup)? Try perhaps increasing the stop time to something extremely long (like 1000 minutes or something).
0
ofafa72Author Commented:
I found a solution from another post- the processes complete as expected if the user is logged on. Previously, I was restarting my PC  every night and would only log back on every morning. I still restart my PC every night but log back on before I leave for the night. It has been working perfectly for the last two weeks now.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.