Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS Job not running (time change)
David.E.M...._at_gmail.com wrote:
>>1/8640th of a day.
> Ummm, elaborate please...
Here's the DBMS_JOB syntax
dbms_job.isubmit (
job IN BINARY_INTEGER, what IN VARCHAR2,
next_date is TRUNC(SYSDATE)
interval is 'TRUNC(SYSDATE)+(1/8640)'
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Feb 09 2006 - 13:51:47 CST