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, 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 Sun Jul 22 2007 - 06:36:47 CDT