| schedule mapping process [message #211994] |
Wed, 03 January 2007 07:24  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
