473,581 Members | 2,789 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Schedule more access applications

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.

Oct 4 '07 #1
0 1227

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

29
11246
by: deko | last post by:
Is there a way to get my script to run on regularly scheduled intervals without using cron? My hosting provider sucks... cannot use cron... I was thinking perhaps I could create a file every hour in a certain directory and then fire the script when the file count reaches a certain number, and then clear out the directory... or something like...
1
3081
by: JackV | last post by:
Hi All, I have a pure asp (Vbscript) page that manipulates data between MSAccess and SQLServer2000. I'm trying to use the Scheduler app on the IIS server to run this page nightly but there must be a better way of doing this. How can I make my code in to an object and install it on the server and have it schedule to run nightly?
0
1716
by: argniw | last post by:
I have a schedule of annual events that need to occur in different locations throughout the year. Each event has a due date associated with it. I also have an optimal schedule that consolidates events by location, by quarter of the year. Therefore, I have two flat files. This one shows what is allowed by quarter of the year:
4
1883
by: TJS | last post by:
does asp.net have anything which will allow scheduling a time based event ?
17
1868
by: nnorwitz | last post by:
For more details about the plan for Python 2.5, see: http://www.python.org/doc/peps/pep-0356/ The highlights are that we are hoping to put out the first alpha Real Soon Now, hopefully in a week or two. If there's something you really think just must be in 2.5 and can't wait until 2.6, now is the time to speak up. (Actually, it was time...
3
8739
by: tstutting | last post by:
Hello, This is my first post and I'd really appreciate any help I can get. Sorry this is so long but it's complicated. I'm a USAF Officer and I'm attempting to make a shared MS Access DB that contains Training, Certification and Scheduling of Crew Members. I've got most of the back-end done (Tables with Relationships) and I'm happy with the...
2
2033
by: ramdil | last post by:
Hi All I have a doubt regarding the scheduling a task in msaccess.I want to write a query which will insert into a temporary table from a exisiting table.I have written the insert query but i want this query to be executed automatically every midnight..How can i schedule it.I know about windows scheduler,but dont know can i schedule access...
2
7699
by: ami'n | last post by:
i'm also not newbie to Access but i'm not programmer. I have a need to automate some task in Access. Every monday which is the first day of the week, I have to send a MS Excel file containing data which generated by MS Access. In my MS Access, I queries and filter a lot of data from Oracle database which I connect using ODBC. In this query,...
2
1618
samikhan83
by: samikhan83 | last post by:
i love mysql..... i have my applications running on mysql database... everything works fine..... if i execute the back up manually i am getting the full back up...... i am having the problem with schedule back up... how i need to configure schedule back feature....i followed all the step given in mysql manual but i am not getting the...
0
7882
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8181
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6564
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5366
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3835
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2309
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1410
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1145
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.