Re: SQL/PL 2.2 - dbms_job.submit

From: Dan Rippel <jford_at_mail.erols.com>
Date: 1996/05/16
Message-ID: <4ncfes$370_at_news6.erols.com>#1/1


The interval parameter is NOT a date field. It is a string that evaluates to a date.

To set an interval less than a day you need to use something like (and dont forget the quotes)
'SYSDATE + 1/24'
This will set the interval to every hour. Basically you add a fraction of a day to SYSDATE.

jjoslin_at_concentric.com wrote:

>sorensen <sorense_at_hsd.utc.com> wrote:
 

>>Hello,
 

>>I have a question about dbms_job.submit and dbms_job.isubmit. I haven't
>>been able to figure out how to get the interval and next_date parameters
>>to allow for increments of less than one day.
 

>>If anyone happens to have any information on a solution to this problem
>>that would be great.
 

>>Thanks in advance.
 

>>Todd R. Sorensen
>>Oracle Developer
>>Hamilton Standard
>>sorense_at_hsd.utc.com

>Todd,
 

> The interval fields are DATE fields, just specify the full
>timestamp (mm-dd-yy hh:mm) and you're off... I had the same problem
>myself not long ago and that's the answer they (Oracle) gave me.
 

>Jim Joslin
>BellSouth Telecommunications
Received on Thu May 16 1996 - 00:00:00 CEST

Original text of this message