When publishing an automation script to TIC, is there a way to schedule the script to run once every 2 hours from 9:45 am to 1:45 pm (3 times each weekday)?
I can set up this type of automation schedule in toad data point on my desktop, but haven't located a way to do this kind of automation schedule within TIC. It doesn't appear that TIC uses the Task Scheduler to set up schedules - is there some other software that I can work with to set up these kinds of schedules?
There are other scheduling options that I would like to utilize if I could find additional options under TIC.
I have two ideas for this. You can install Toad Data Point on the server and use the task manager in the same way you do on your desktop. This would be independent of Toad Intelligence Central.
Or, you could rewrite your automation script to run only once a day. Put your activities in a loop and add a 2 hour Pause activity at the end of our activities. Here you can control the number of times you loop through your activities and the amount of time to wait between executions.
I did try your 2nd idea - a single automation with a pause. It seemed to function properly, but then I tried setting up a different automation that was scheduled to run during the pause period, and neither automation ran. When viewing the scheduling list for the 1st job (the one with the pause), the status is shown as “running” during the pause period, so I wondered if another job could run at the same time. Is it possible to have multiple jobs running while another is paused?
I am thinking that perhaps another alternative is to schedule 3 separate automations, basically running the same script 3 times with different start times throughout the day.
OK. I now have this set up as 3 separate automation scripts.
I am guessing that the scheduling option works as it is intended, so debugging is probably not necessary. It could be an enhancement, however, as it would be best if we could set up this kind of schedule directly through the TIC scheduler, just like we are able to do in Toad Data Point.