Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple step jobs in Scheduler in 10g with differnt type of steps(2 procedure and executable)
On Jul 22, 3:36 pm, "Vladimir M. Zakharychev"
<vladimir.zakharyc..._at_gmail.com> wrote:
> On Jul 22, 9:09 am, rateesh <rateeshmo..._at_gmail.com> wrote:
>
> > 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
>
> No Oracle version, so I'm assuming 10g R2 (10.2). Research job chains
> in the Administrator's Guide. This functionality is not available in
> previous releases so if you're on 10.1 then you will have to manually
> chain your jobs somehow.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Hi,
Thanks for your reply.I am using Oracle version 10g R2. I had researched chains but i could not find an option of having multiple steps of different types having to validate successful completion based on return value. In chains each step can be either program, subchain or event_schedule. am i right i guessing that if i am to use chains i should have one program for executable and another program for stored procedure and call it one by one. Further how can i validate the successful completion of the executable program based on return value from the executable program.
Regards,
Rateesh Mohan
Received on Mon Jul 23 2007 - 00:40:16 CDT