Schedule tasks

[Guest]

Hello,

I'm using the Microsoft Scheduler to schedule 6 access application.
Each application is scheduled on a different time starting at 03:00 am
and the last one is scheduled 07:30 am.
The applications are build to check if a triggerfile is available,
otherwise the procedure is canceled.
Now to avoid having no results, I want to find a solution to start all
6 application in 1 "big" application and schedule it every 30
minutes.
If at 03:00 am the first triggerfile is not available, the next
scheduled taks will start at 03:30 am.
If the triggerfile is available, the applications can run otherwise a
new scheduled task can start running at 04:00 am.
I was thinking of an VBScript that contains all 6 applications. So I
only have to schedule 1 application every 30 minutes.
To avoid that if the first scheduled application is running on time
and after 30 minutes the second would do the same all over again, I
send a checkfile at the beginning of the procedure to have something
to check so the next scheduled task can be aborted after finding the
checkfile.


Does anyone have any idea how to solve my problem.

 

[Roger Carlson]

Well, I don't often recommend commercial solutions, but you might want to
look at Total Visual Agent by FMS.
http://www.fmsinc.com/Products/Agent/index.html

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Roger,
the commercial solution is indeed very nice, but I do not want to spend
money for something, I think, is much more than I need. I was thinking it can
be done with something like a batch file or VBScript that contains the
scheduled Access applications. Then I can schedule the batch file every 30
minutes.
So, what I need is an easy way to create this.
But thank you anyway for your respond.