Oracle-L: RE: schedule job past 15 mintues every hour.

From: kkennedy <kkennedy_at_firstpoint.com>
Date: Wed, 07 Aug 2002 14:16:37 -0800
Message-ID: <F001.004AE2E6.20020807141637@fatcity.com>

Try 'TRUNC(SYSDATE+1/24,'HH')+15/1440'.
The 15/1440 adds 15 minutes (24 hrs/day * 60 mins/hr = 1440 mins/day). Note the 'HH' parameter on the trunc so that we trunc to the start of the next hour instead of truncating to the default of midnight.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE! What can this mean?

-----Original Message-----
Sent: Wednesday, August 07, 2002 9:40 AM To: Multiple recipients of list ORACLE-L

Hi,

I am trying to change job schedule time to 15 minutes past every hour.

SQL> EXECUTE dbms_job.interval(14, 'TRUNC(SYSDATE + 1/24)'); ------ job will run at 8:00, 9:00, 10:00......etc

SQL> EXECUTE dbms_job.interval(14, 'TRUNC(SYSDATE + 1/48)'); ------ job will run at 8:00, 8:30, 9:00......etc

How to change the time if I want to run the job every hour past 15 minutes like......8:15, 9:15, 10:15.....etc

I appreciate your input.

Thank you!
Muqthar Ahmed
Database Administrator

--

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

Author: Muqthar Ahmed
INET: Muqthar.Ahmed_at_decoratetoday.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: kkennedy
INET: kkennedy_at_firstpoint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------