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

From: <nettmaster_at_my-dejanews.com>
Date: Sun, 10 Jan 1999 04:53:22 GMT
Message-ID: <779bo2$l0t$1@nnrp1.dejanews.com>

Take a look at the dbms_job package.

In article <776bp5$jng$1_at_romeo.dax.net>,   "Stein Andersen" <stein.andersen_at_c2i.net> 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.
>
>

---

jeff grant, it manager, nettwerk productions http://www.nettwerk.com http://www.nettweb.com mailto:nettmaster_at_my-dejanews.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Jan 09 1999 - 22:53:22 CST