dbms_job submission with condition

[Kumud]

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

[marist89]

I would create a wrapper script that called your procedures in order. If an exception is encountered, send mail to your pager.

[Kumud]

Will you please send me some details or url for wrapper