Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Time based triggers?
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