Re: SQL/PL 2.2 - dbms_job.submit
From: <jjoslin_at_concentric.com>
Date: 1996/05/12
Message-ID: <4n6u6n$p5n_at_tribune.concentric.net>#1/1
Date: 1996/05/12
Message-ID: <4n6u6n$p5n_at_tribune.concentric.net>#1/1
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 Sun May 12 1996 - 00:00:00 CEST