Run Procees Flow from Command Line or SQL+

Uli Bethke Oracle Warehouse Builder

You can run a process flow from the command line. This is useful if you want to call a process flow from another application, e.g. if you want to use a 3rd party scheduler like AT or Cron etc. or if you want to script the execution of your process flows.

You need to call the sqlplus_exec_template.sql from sqlplus ...

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 ...