schedule job past 15 mintues every hour.

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Wed, 07 Aug 2002 08:40:10 -0800
Message-ID: <F001.004ADAE2.20020807084010@fatcity.com>

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). Received on Wed Aug 07 2002 - 11:40:10 CDT