hi!
I have three batch procedure proc_1, proc_2,proc_3
I want to submit batch jobs in such a way that 2nd job should start after completion of 1st job and 3rd job should start after completion of 2nd.
Also if any of the job is unsuccess should notify via email.

Does any body has done this using oracle.
(not using unix cron job or any scripting...)

Any help appriciated