locked
Question on running a scehduled task PROPERLY? RRS feed

  • Question

  • Hi,

    Any help with this one?

    REPOSTED HERE AT DAVID F (MODs) SUGGESTION.

    I have an Access 2007 DB on a shared folder on the network.  I want 4 users to be able to boot up, and have that DB open when they are logged in.

     This works when you schedule running a program that is on the local drive, e.g. Open note pad or another prog. This ALSO works with files on the network eg docx or xlsx files, just not .accb files.

     When I do the following...

    Create New task (not basic)

    Task name  Open DB > Run when user logged on (they have to be anyway)  use with highest privileges = yes > Configure for Vista or server 2008 ( Using Vista Bus, and SBS 2003)

     Trigger > At Log on OR startup> Specific user or group (ME) Enabled  checkbox = Yes

     Action > Start a program >  Browse to program/script = Z drive/ database-name.accdb

     Conditions - none set (ac power obviously)

     Settings >  allow task to run on demand - stop after three days (even I don't work that long!)

     Click RUN to see if it works. Nothing happens

     (It appears to kick off ok but then just does nothing, there are error messages displayed in the History tab, as below)

    Task id 319 received a message from Task Scheduler service requesting to launch task

    Task id 100 task started

    Task id 200 action started

    Task id 203 action failed to start

    Task id 103 action start failed

     

    Any suggestions, has anyone done anything similar?

    Tried several variations on the settings, still  no joy.

    Thanks in advance. McP

    Thursday, November 17, 2011 4:07 PM

Answers

  • Hi,

     

    Does it work on other computers?

     

    Do you find any event logs related to this issue? You can check the Task Schedule logs under Event Viewer\Application and Service Logs\Microsoft\Windows\TaskSchedule.

     

    You can refer to the following link to upload the information:

     

    http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65

     

    Regards,

     

    Sabrina


    This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Sabrina Shen Friday, November 25, 2011 5:59 AM
    Tuesday, November 22, 2011 5:12 AM