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
Update Query using Oracle Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
Re: Update Query using Oracle Enterprise Stage
Vijay Kumar wrote: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
One method would be :
Create a procedure that implemets ur update functionality
and call tht procedure in Target OCI Stage in CLOSE COMMAND Property, so the procedure will be executed after completing all the operations on tht table.
"Attitude always and almost determines the altitude of your Life"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: