From oracle-l-bounce@freelists.org Wed Mar 2 16:10:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j22MA5H5032070 for ; Wed, 2 Mar 2005 16:10:05 -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 j22MA5em032066 for ; Wed, 2 Mar 2005 16:10:05 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 68B777C6C4; Wed, 2 Mar 2005 16:08:39 -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 32758-02; Wed, 2 Mar 2005 16:08:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DEF2A7C8A5; Wed, 2 Mar 2005 16:08:38 -0500 (EST) X-Server-Uuid: E506CC0A-1472-4699-B4CF-B6BEE0793AD9 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: DBMS_JOB Date: Wed, 2 Mar 2005 15:05:59 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DBMS_JOB Thread-Index: AcUfR75prcnIh1Q0R8Oob+B/xGBu3AAI9l+Q From: "Dirschel, Steve" To: oracle-l@freelists.org X-OriginalArrivalTime: 02 Mar 2005 21:06:00.0451 (UTC) FILETIME=[A2E07D30:01C51F6B] X-WSS-ID: 6E38F5321T4504336-01-01 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 16831 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Steve.Dirschel@bestbuy.com Precedence: normal Reply-To: Steve.Dirschel@bestbuy.com 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=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: 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). When I schedule the job via this command: execute dbms_job.submit(job=3D>:jobno, what=3D>'program_name;', next_date=3D>trunc(sysdate+1)+1/48, interval=3D>'trunc(SYSDATE+12/24,''HH'')'); It works as expected. But the problem I have is if the job gets broken or the db is down the next time it executes it will schedule itself 12 hours in the future- if it happens to run at 2:10am then the next run would be 2:00pm. Is there a way with 1 job to force it to only run at 12:30am and 12:30pm regardless of the time of current execution? Thanks -- http://www.freelists.org/webpage/oracle-l