Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Multiple step jobs in Scheduler in 10g with differnt type of steps(2 procedure and executable)

Multiple step jobs in Scheduler in 10g with differnt type of steps(2 procedure and executable)

From: rateesh <rateeshmohan_at_gmail.com>
Date: Sat, 21 Jul 2007 22:09:10 -0700
Message-ID: <1185080950.280165.31420@r34g2000hsd.googlegroups.com> 





Hi Guys,




Is it possible to run a job which has multiple steps serially on after
the other i.e. I have a 2 stored procedure and one executable whcih
needs to be run as follows. First one stored procedure must be run
and once it finishes successfully another executable has to be run
which also gives a return value and if that is also sucessfull then
another stored procedure has to run. How is this possible in
DBMS_SCHEDULER. Any Hints





Thanks,


Rateesh
Received on Sun Jul 22 2007 - 00:09:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US