Update Query using Oracle Enterprise Stage
Posted: Thu Sep 14, 2006 9:12 am
Hi,
Based on successful execution of a job I want to update an Oracle table.
So I want to execute an update query in a new job which will be executed after the First Job.
What is the best method to run the update query in a job(for all other jobs which reads data from Oracle I am using Oralce Enterprise stage)
Can I use the same Oracle Enterprise Stage to perform this task.
If yes, can any one explain how to do it?
Regards,
Vijay
Based on successful execution of a job I want to update an Oracle table.
So I want to execute an update query in a new job which will be executed after the First Job.
What is the best method to run the update query in a job(for all other jobs which reads data from Oracle I am using Oralce Enterprise stage)
Can I use the same Oracle Enterprise Stage to perform this task.
If yes, can any one explain how to do it?
Regards,
Vijay