How To Assign Scheduled Jobs To a Service That Can Be guaranteed To Be Started After The Control Center Service Is Started
Last updated on JUNE 19, 2017
Applies to:Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.
Oracle Warehouse Builder (OWB) Schedules are deployed to the Oracle DBMS_SCHEDULER, which will make calls to the OWB Control Center Service to initiate the ETL activity.
If there is a database outage for a period of time, there is a possibility that the DBMS_SCHEDULER will start to call jobs that should have started during the outage period, before the Control Center Service can be started. In this case the ETL will fail.
Assigning the scheduled task to a Service that can be started manually after the Control Center Service has started will ensure that the Control Center Service is available for the delayed schedules.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms