Complex Schedule OWB

Uli Bethke Oracle Warehouse Builder

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.

owb audit_id

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.