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 -> Re: DBMS Job not running (time change)

Re: DBMS Job not running (time change)

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 09 Feb 2006 11:51:47 -0800
Message-ID: <1139514697.562328@jetspin.drizzle.com>


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 IN DATE,
interval IN VARCHAR2 DEFAULT 'NULL',
no_parse IN BOOLEAN DEFAULT FALSE);

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

Original text of this message

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