Oracle-L: RE: DBMS

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Tue, 18 Feb 2003 07:09:26 -0800
Message-ID: <F001.005502D8.20030218070926@fatcity.com>

Mark,
You may want to check http://asktom.oracle.com. I think there are a few examples that you will find come close to what you are looking for.

Kirti

-----Original Message-----
Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L

Hi All,

Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am > 03:00am)?

All help appreciated! Pointers to RTFM more than welcome! ;)

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: DBMS_JOB