Hi all,
I want to allow script to run a particular day. Let's have this example to illustrate:
- jobs are scheduled in the night of the last workday of the month to the day after
- script S has to be executed the day after last workday of the month (past midnight)
How is it possible to implement that with TimeWindows?
First, I thought that it'd possible to use multiple time intervals to get a combination that satisfied my need:
- Time interval for the last workday from 8pm till midnight
- first workday from midnight to 7am
- first saturday from midnight to 7am (in case, the last workday is a friday)
But using this method allow the script to run at unexcepted times.
Then, I saw the period functions "Last workday in month [-x] [to last workday in month [-y]]" that sounds good but :
- period is only during a particular month, cannot be extended to the first worday of the next month
- there is only functions for last workday but nothing for first ones
I think it would be possible to implement myself the period functions needed, but Oracle functions cannot be exported with our current import/export tool.
Finally I have no idea how to implement that. Have you any clue?
Thanks in advance.
Regards,
Yi Jiang