[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 693
  • Last Modified:

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.
0
ofafa72
Asked:
ofafa72
  • 3
  • 2
3 Solutions
 
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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now