How do I get to scripts to run under the scheduler

Question

0.00/5 (No votes)

See more:

I have a weather station from which I get a daily data file in the form of a tab delimited test file, which includes the the date in the form YYMMDDtextfile.txt.

I have written a script which copies this file to a file called AccessUpload.txt, which is scheduled to run every day at 02:10.
This appears to happen OK because the this file always contains the correct days data. However the scheduler is giving a last run result of 0x41303 which is saying it has not run. the last run date also shows 30/11/1999 00:00:00. However the history is showing it has run. The script runs fine when I double click it from Windows explorer.

I then have a second script file to move the data into an access database. This also runs ok manually. I have scheduled it to execute at 02:15. The scheduler again is showing the same last run result, but the history indicates it timed out.

What I have tried:

I have checked all of the properties for the scheduler events and cannot see what the problem is. I do wonder if the second script is not running because the system is saying the file copy is not complete due to the problem with the first event, but the actual files seem fine.

Any suggestions would be most helpful

Posted 27-Oct-17 6:16am

Member 13485326

Add a Solution

Comments

CHill60 27-Oct-17 14:12pm

Is there anything in the event log to give you a clue? Have you tried running a dummy script that just pipes the time to a text file?

Member 13485326 28-Oct-17 0:44am

The data is going through a spreadsheet which uses a couple of events to trigger a batch file copy and a script. These ehave been running OK for months.

I have found one apparent issue, I changed the events from run only when user is looged on from run whether user is logged on or not. The file copy script is now showing an error free completion, and the Acccess update event script has run because the data is there. However the scheduler is just showing the last runs as my manual runs from within the scheduler.

This suggests to me this is a security issue.

Member 13485326 1-Nov-17 1:34am

I have now deleted the original event and recreated it to only rum under my own User ID and it has run successfully. I am not sure what the issue was but this has soved it. Thanks for the help.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)