f



Calling Job from a Job..

Hi,
Is it possible to call a job after finishing a Job.Example I have two
jobs Job1 and Job2.
How should I call Job2 after finishing Job1.Can I trap any returning
value after successful execution of Job1.I know its possible through
ETL tools.
But I need to do the same without ETL.
Regards
AC

0
4/12/2006 7:03:24 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

2 Replies
1191 Views

Similar Articles

[PageSpeed] 43

If you use Oracle 10g DBMS_SCHEDULER offers some tricks. But, in your
case I would take into account the possibility to merge the procedures
behind each job into one single procedure called from the Job1.

alec.

0
4/12/2006 7:11:59 AM
Thanks Alek,
Thanks for your help.
Regards
AC

0
4/12/2006 9:36:18 AM
Reply: