Skip to Content
0
Former Member
Feb 24, 2009 at 02:44 PM

Implementation of complex Time window

32 Views

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