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

Hi,

The version is Oracle 10g r2. I had reasearched on chains but couldnt find any information whether steps can be of differnt type .

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
Received on Mon Jul 23 2007 - 00:31:30 CDT