>In article <6fspcn$ijo$1_at_juliana.sprynet.com>,
> "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.
>>
>> TIA
>>
>> Scott Green
>> twogreens_at_sprynet.com
>>
>>
Check out the DBMS_JOB package. This will accomplish what you want and keep
the entire solution within Oracle.
G.
Gerard M. Averill, Associate Researcher
CHSRA, University of Wisconsin - Madison
GAverill_at_chsra.wisc.edu
Received on Fri Apr 10 1998 - 11:48:53 CDT
