From oracle-l-bounce@freelists.org Thu Mar 3 10:06:42 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j23G6fO7014555 for ; Thu, 3 Mar 2005 10:06:41 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j23G6fem014551 for ; Thu, 3 Mar 2005 10:06:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAA957D0C6; Thu, 3 Mar 2005 10:05:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01599-10; Thu, 3 Mar 2005 10:05:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 27A9F7CF62; Thu, 3 Mar 2005 10:05:14 -0500 (EST) Message-ID: <02ba01c52009$e94c1880$e300a8c0@user12344> From: "Yechiel Adar" To: References: Subject: Re: DBMS_JOB Date: Thu, 3 Mar 2005 17:58:58 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-archive-position: 16876 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adar76@inter.net.il Precedence: normal Reply-To: adar76@inter.net.il X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=1.0 required=5.0 tests=AWL,FROM_ENDS_IN_NUMS autolearn=no version=2.60 X-Spam-Level: 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" To: 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