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
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.