Re: SQL/PL 2.2 - dbms_job.submit
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