Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Time based triggers?

Re: Time based triggers?

From: Donald G. Bowles <dbowles_at_praca.ksc.nasa.gov>
Date: 1998/04/02
Message-ID: <6g0l9f$r5f@niven.ksc.nasa.gov>#1/1

S Green wrote in message <6fspcn$ijo$1_at_juliana.sprynet.com>...
>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.
>
>TIA
>
>Scott Green
>twogreens_at_sprynet.com
>
>

You can schedule your PL/SQL run from
within the database using the Oracle supplied package DBMS_JOB.

Don Received on Thu Apr 02 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US