Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_JOB

Re: DBMS_JOB

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 3 Mar 2005 17:58:58 +0200
Message-ID: <02ba01c52009$e94c1880$e300a8c0@user12344>


Next date accept date value.
Why not write your own little function that will return the correct time for next run and use this instead of sysdate.

Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "Dirschel, Steve" <Steve.Dirschel_at_bestbuy.com> To: <oracle-l_at_freelists.org>
Sent: Wednesday, March 02, 2005 11:05 PM Subject: DBMS_JOB

> Oracle 9.2
>
> We want to schedule a job via DBMS_JOB to run at 12:30am and 12:30pm.
> I'd prefer to schedule 1 job to do this rather than 1 job to run at
> 12:30am and 1 job at 12:30pm (I don't want them to run on top of each
> other).

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 03 2005 - 10:06:42 CST

Original text of this message

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