Scheduled tasks are not completing

Posted on 2008-11-18
Last Modified: 2012-05-05
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.
Question by:ofafa72
    LVL 1

    Assisted Solution

    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.
    LVL 84
    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?

    Author Comment

    The three modules are independent of each other and yes I am using a start up form to fire them.

    Author Comment


    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?
    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    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).

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now