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

Use oracle supplied package DBMS_JOB.

Srini

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Swajit Satam
Sent: Thursday, May 25, 2000 1:10 PM
To: Multiple recipients of list ORACLE-L Subject: Execute a procedure depending upon time or at a regular interval

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