Skip to Main Content

Creating Jobs In Oracle 10g

Gagan Deep KaushalAug 26 2008 — edited Aug 26 2008
Hi All,

I need to create a job in PL/SQL which execute different procedures sequentially.What i exactly need is to schedule 3 different procedure and one package which are dependent on each other so if first procedure fails second does'nt execute.As i know i can associate only one procedure/package with single job.So how i can call three different procedures at a time .I am using Oracle 10g .So can DBMS_SCHEDULER help me?

Please Help.


Regards:
Gagan Deep Kaushal
Comments
Post Details
Added on Aug 26 2008
5 comments
315 views