Complex Schedule OWB

June 29, 2008

OWB has the By Clause to create complex schedules. Imagine you have a near real time ETL process that needs to execute every 15 minutes between 7 am and 0 am. You don’t want this schedule to execute during the night because other maintenance operations such as stats gathering etc. need to run.

Step 1:

Create a schedule with your start date and a start time of 7:00:00 am. As repeat expression for this job specify minutely and set the frequency to every 15 minutes.

Step 2:

Specify the By Clause to create the complex schedule: click on By Hour and enter 7 am – 0 am.