Re: How to do automatic Periodic Maintenance with triggers/procedures ?

From: Reid Lai <reidlai_at_hk.super.net>
Date: Sun, 10 Jan 1999 14:59:32 +0800
Message-ID: <36984FD3.2FF89863@hk.super.net>

Try to use built-in package DBMS_JOB. It is used to maintain Oracle Job Queue.

Stein Andersen wrote:

> Concerning Oracle Server 7.3.x and 7.2.x on Windows NT (and UNIX),
>
> In a database I am setting up, I have the need to execute some SQL with
> certains intervalls (a few hours). I am currently using an at-command
> in Windows-NT/Unix to insert a row in a tabel, and as a result of that a
> trigger
> which does the actual job is fired.
>
> Does anybody know about a way in the basic server-installation for 7.2/7.3
> to
> execute a trigger or procedure on a given time, or with regular intervalls.

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Jan 10 1999 - 00:59:32 CST