Re: DBMS_JOB

  • From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 3 Mar 2005 17:58:58 +0200

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@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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).


--
//www.freelists.org/webpage/oracle-l
  • References:

Other related posts: