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 -> Re: DBMS_JOB

Re: DBMS_JOB

From: sybrandb <sybrandb_at_gmail.com>
Date: 28 Feb 2007 02:13:54 -0800
Message-ID: <1172657633.971808.52160@h3g2000cwc.googlegroups.com>


On Feb 28, 10:54 am, uramnathk..._at_gmail.com wrote:
> Does DBMS_JOB always run on creation of the job. I dont want the job
> to run on creation but only during the specified interval.Is there any
> way?

Dbms_job does only run on creation of the job when you *ask* it do so. Please refer to the documentation for the dbms_job.submit procedure on how to specify a different start date.
Please do NOT ask doc questions here.

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Feb 28 2007 - 04:13:54 CST

Original text of this message

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