Re: Time based triggers?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/02
Message-ID: <6fuuim$dfq@bgtnsc03.worldnet.att.net>#1/1

On Wed, 1 Apr 1998 01:14:30 -0600, "S Green" <twogreens_at_sprynet.com> wrote:

>I want to schedule PL/SQL modules to run periodically. Can this be done via
>a trigger? What other options exist. I suppose that I could call the
>routines from a cron job, but this does not seem very elagant.

You need to look into the DBMS_JOBS package. It will do what you want, in other words it will let you schedule PL/SQL code to run at scheduled intervals. For the life of me though, I can't remember what manual Oracle documents that in. Received on Thu Apr 02 1998 - 00:00:00 CST