Home » Developer & Programmer » Warehouse Builder » schedule mapping process
schedule mapping process [message #211994] Wed, 03 January 2007 07:24 Go to next message
ashraf_oh@hotmail.com
Messages: 9
Registered: October 2006
Location: Egypt
Junior Member
i already created mapping process that extract date from dept table and load the result into target table and this action is done successfully
now i want to schedual this mapping process every day at 8 o'clock morning

so please help to schedual the mapping process ?
Re: schedule mapping process [message #215139 is a reply to message #211994] Fri, 19 January 2007 07:50 Go to previous messageGo to next message
jvalerof
Messages: 9
Registered: September 2006
Junior Member
One way to schedule the mapping is:

1. Create a Workflow in OWB and put the mapping.

2. Use the API of OWB to run this Workflow. It's a package in RUNTIME schema called Wb_Rt_Api_Exec. In a short way, you must do Wb_Rt_Api_Exec.OPEN and Wb_Rt_Api_Exec.EXECUTE the workflow.

3. If you have written a (for example) procedure in point 2, you can make a dbms_job scheduling and you have it.

Hope it helps
Re: schedule mapping process [message #218479 is a reply to message #215139] Thu, 08 February 2007 06:25 Go to previous message
ashraf_oh@hotmail.com
Messages: 9
Registered: October 2006
Location: Egypt
Junior Member
Dear jvalerof
i really appreciate your response and would like to help me to execute step no 2 in your answer cause i don't how to execute it. wish to send me your tel no to caontact you soon
best regards
Previous Topic: file exists
Next Topic: Retrieve AUDIT_EXECUTION_ID
Goto Forum:
  


Current Time: Wed Jul 30 04:12:40 CDT 2014

Total time taken to generate the page: 0.21265 seconds