How can put a trigger for a job at each 2 minutes for all the days of the week but on each Sunday, between 5:00 and 5:30, I don't want the job runs.
It is really too long and not very useful to schedule each time of the day I want the job runs.
How can put a trigger for a job at each 2 minutes for all the days of the week but on each Sunday, between 5:00 and 5:30, I don't want the job runs.
It is really too long and not very useful to schedule each time of the day I want the job runs.
Hello Dear Samantha, I have a problem little different. I have got my script to launch a program that runs a database.It creates a folder with the DB name and copies a backup copy into it...then continues on to launch program. As this program does NOT have a timed backup or incrimental backup i am trying to do it in WA. So basically, how can i have WA make a backup every 5 minutes while working on the database. WHY? Because sometimes i have entered wrong info and realise it starts to crash, and every 5 minutes (or adjustable) would be good, i can go back to and INCREMENTAL backup and load that up and continue from there. Secondly...can this be accomplished with the "date" feature somehow because i noticed if i give this "COMPILED" exe to someone else it wont work as they dont have WA . Thanks for your help....... Robbie PS: i can PM you the 'waj' if you like :P
Hi Robbie,
You seem to have gone into deep waters with WinAutomation!
What you are describing seems a nice procedure to automate, and of course can be automated.
How big is your database? How long does it take WinAutomation to read through the whole table?
I'm only asking, just in case you are trying to change things around while backing up the database might cause some issues (just making sure)
Yes, you could use a date feature, but I would need to first understand what it is you are changing within the database, and if these changes are being logged into a column or not (i.e. last modified)
:)
Samantha
Rome wasn't built in a day..
Hello Nattur!
There's actually a way around it.. but i can only wonder what job you want to run every 2 minutes!!!
Anyway.. All you have to do is add these actions before your Job's actions..
- Get Current Date Time
- If Action (%CurrentDateTime.DayOfWeek% = Sunday)
- If Action (%CurrentDateTime.Hour% = 17)
- If Action (%CurrentDateTime.Minute% <= 30)
- End Job
You also add a recurring trigger to the job to run every 2 minutes.. and you're ready to go!
This way, the job will check whether the day is a Sunday, and won't run the job between 17.00-17.30!
Your job should look something like this:
:)
Samantha
Rome wasn't built in a day..
Rome wasn't built in a day..