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