Re: dbms_job.isubmit

On Wed, 28 Feb 2007 17:30:01 -0500, "Ed" <ed_at_mail.com> wrote:

>I just want run a Job once in background
>And I want to define my own job number.
>
>For "isubmit" the 3rd param (next_date) is required
>
>Question...Is this:
>
>dbms_job.isubmit (
>job => 1234,
>what => 'foo.sp_bar;',
>next_date => NULL)
>
>
>EQUIVALENT to
>
>
>dbms_job.submit (
>job => var_oracle_job_number,
>what => 'foo.sp_bar;')
>
>?
>
>thanks
>10g
>

I think next_date->sysdate is what you need. If a job fails, it'll retry 16times, FYI.
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Mar 01 2007 - 22:29:28 CST