RE: Execute a procedure depending upon time or at a regular inter

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 25 May 2000 09:12:34 -0500
Message-Id: <10508.106680@fatcity.com>

The NT "AT" command won't work? I use it all the time. Ron Smith
Database Administration
rlsmith_at_kmg.com

-----Original Message-----
From: Rocky Welch [mailto:rockyw_99_at_yahoo.com] Sent: Thursday, May 25, 2000 9:49 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Execute a procedure depending upon time or at a regular interval

Hi Swajit,
Consult the Oracle documentation about the DBMS_JOB package which works just like Unix cron. The good part is that it is internal to Oracle and the database.

HTH,

• Swajit Satam <swajit_at_mahindrabt.com> wrote:
  > Hi
  >
  > Can I Execute a procedure depending upon time or
  > say at a regular interval (like Triggers but triggers are
  > event driven ).
  > If it's a Unix box then I can write a cron job but if it's a NT Box then
  > it cannot be achived so can it be done inside Oracle itself so that i
  > dont have to depend no O/S. or is there any work around for the same.
  >
  >
  > TIA
  > Swajit
  >
  >
  >
  >
  > --
  > Author: Swajit Satam
  > INET: swajit_at_mahindrabt.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).
  

  ---

Rocky Welch
Oracle DBA Consultant

rockyw_99_at_yahoo.com

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

-- 
Author: Rocky Welch
  INET: rockyw_99_at_yahoo.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

Received on Thu May 25 2000 - 09:12:34 CDT