Have a small app that queries a table, pus it in a spreadsheet and emails it out. Worked fine for several months using the Windows Task Scheduler. Now all of a sudden it's refusing to run the app. If I run it from outside of the schedule it works fine!
Is there a way to run the app using another VFP app?
TIA, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
When I've had similar issues it's normally somebody has moved the app or supporting files or changed the password of the user who is so to run the task.
Does the task scheduler show you an error code for the last run?
On 13 March 2019 19:38:49 GMT-04:00, Desmond Lloyd desmond.lloyd@gmail.com wrote:
Have a small app that queries a table, pus it in a spreadsheet and emails it out. Worked fine for several months using the Windows Task Scheduler. Now all of a sudden it's refusing to run the app. If I run it from outside of the schedule it works fine!
Is there a way to run the app using another VFP app?
TIA, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Desmond,
A couple of questions.
1) Any idea if you are getting any error messages? Any logs you might look at? 2) Will the scheduler run a batch file? If so, could that start the VFP app? 3) You could always write your own scheduler using VFP and set it so it runs on startup. 4) You might try creating a simple VFP app that simply starts up, writes a message to a file, then closes down to see if that works. If so, then it may be a matter of tracking down what is preventing the real app from running (memory allocation, thread conflict, etc.)
Hope one of these helps,
Fletcher
Fletcher Johnson FletcherSJohnson@Yahoo.com LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Desmond Lloyd Sent: Wednesday, March 13, 2019 4:39 PM To: ProFox Email List Subject: VF9 - Running an app on a schedule....
Have a small app that queries a table, pus it in a spreadsheet and emails it out. Worked fine for several months using the Windows Task Scheduler. Now all of a sudden it's refusing to run the app. If I run it from outside of the schedule it works fine!
Is there a way to run the app using another VFP app?
TIA, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
-
Desmond Lloyd -
Fletcher Johnson -
Frank Cazabon