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 and setting the interval

dbms_job and setting the interval

From: Seth <sgelberg_at_optonline.net>
Date: 15 Oct 2001 16:01:52 -0700
Message-ID: <f3159b28.0110151501.795ccb23@posting.google.com> 





Can you specify a variable to use as the interval value in the
dbms_job.submit:



for ex:



    v_matchInterval     CONSTANT    NUMBER := 10/86400; -- 10 Seconds


.

.

.



   DBMS_JOB.SUBMIT(jobno, 'matching.matchfacade;', sysdate, sysdate +
v_matchInterval);
Received on Mon Oct 15 2001 - 18:01:52 CDT












Original text of this message













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