OWB - Mapping and Process Flow Scheduling

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - Steps

  • Navigate to the Schedules node in the Design Center Console and create a new Schedules module called MY_SCHEDULES. For the location, select your TARGET_LOCATION, as the schedule will be deployed to the database.
  • Create a new schedule, TEST_SCH, with time greater than current database machine time (server where the job executes).
  • Associate your schedule with the mapping or process flow. Right click the mapping or process flow and select the option “Configure” and “set Referred Calendar” to TEST_SCH.
  • In the Control Center Manager, navigate to your TARGET_LOCATION and note the Scheduled Job TEST_SCH_JOB under the Scheduled Jobs node. Deploy the job with action “Create”.
  • Using SQLPlus logged into the database as the TARGET user, verify the user has a job TEST_SCH_JOB, in state DISABLED:
SELECT job_name, state FROM user_scheduler_jobs;
  • Use the Schedule tab on the Control Center Jobs panel in the Control Center Manager to schedule the job. Highlight, right click the job and from the pop-up menu select “start”. Use the same query to check the current status:
SELECT job_name, state FROM user_scheduler_jobs;

The above query will show whether the scheduled job is SCHEDULED, RUNNING or SUCCEEDED.

Advertising

3 - Documentation / Reference