How To Schedule a Mapping or Process Flow as a Job Using OWB 10.2 or 11g

	Doc ID:	602187.1	Type:	HOWTO
	Modified Date :	10-MAR-2009	Status:	PUBLISHED

In this Document
  Goal
  Solution
  References

---

Applies to:

Oracle Warehouse Builder - Version: 10.2.0.1 to 11.1.0.7
Information in this document applies to any platform.

Goal

This Note describes how to schedule a mapping or process flow as a job using OWB 10.2 or 11g

Solution

A new feature introduced from OWB 10.2 and higher which uses DBMS_SCHEDULER of the database for scheduling a mapping or process flow as database job.

1. Create a Schedule:

• In the Design Center, locate the "Schedules" node under the project.
• Create a new module under the "Schedules" node by providing a name and location.
• Create a new schedule under the module and provide time and frequency for the job execution.

NOTE: The location should point to the target schema.

2. Associate the Schedule:

• Locate the mapping or process flow that needs to be scheduled.
• Right click and select the option "configure".
• Set the "Referred Calendar" to new schedule created in previous step.
  

3. Deploy the Scheduled Job:

• Start the Control Center Manager, expand the location and locate the scheduled job.
• Deploy the job with action "create".
• You can verify the job created in the target schema using the below SQL command. 
• The newly created job will be in  DISABLED state.

SQL>select job_name, state from user_scheduler_jobs;

4. Start the Job:

• In the Control Center Manager, go to the Control Center Jobs window and select the "Scheduled" tab.
• Right click on the job and select the "Start" option.
• You can check the job status in the database using the SQL command mentioned in the previous step. i.e It will show the state of the scheduled jobs i.e. SCHEDULED, RUNNING or SUCCEEDED

 

References

Note 305983.1 - Scheduling OWB(10gR1) Mappings Using OEM(10gR1)
Note 359287.1 - How to Schedule an OWB 10g Process Flow or Mapping From OEM 10g