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