Re: periodically running a stored procedure.... how

From: <sybrandb_at_my-deja.com>
Date: Mon, 05 Feb 2001 11:01:27 GMT
Message-ID: <95m165$g3q$1_at_nnrp1.deja.com>


In article <95ls1u$4qn$1_at_news.seed.net.tw>,   "Ron TJ HUANG" <ron_huang_at_psitech.com.tw> wrote:
> Dear all,
>
> Is it possible to set a stored procedure running periodically with
 PL/SQL
> command?
> If yes, how to do this?
>
> Many thanks.
> Ron.
>
>
Please refer to the docs on dbms_job.
Prequisites: job_queue_processes nonzero in init.ora, job_queue_interval nonzero in init.ora

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/
Received on Mon Feb 05 2001 - 12:01:27 CET

Original text of this message