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 -> dbms_job.isubmit

dbms_job.isubmit

From: Ed <ed_at_mail.com>
Date: Wed, 28 Feb 2007 17:30:01 -0500
Message-ID: <12uc0jach6toj7c@corp.supernews.com>


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 Received on Wed Feb 28 2007 - 16:30:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US