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