"DA Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1111188395.995768_at_yasure...
> Randy Harris wrote:
>
> > Does Oracle have a facility to run procedures at specified times? Or
does
> > it need to be externally triggered by a cron sort of thing?
>
> What version?
>
> Oracle 10g and before you can use DBMS_JOB
>
> With 10g far better to use DBMS_SCHEDULER.
>
> Demos of DBMS_JOB package can be found at:
> http://www.psoug.org
> click on Morgan's Library
> scroll down to DBMS_JOB
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Thanks Daniel. The example in Morgan's Library was extremely helpful. My
server is currently at 8.1.7.4. I'm expecting an upgrade in the not very
distant future, but I don't yet know whether we'll be going to 9i or 10g.
Meanwhile, it looks as though DBMS_JOB is just what I needed.
Received on Fri Mar 18 2005 - 21:35:18 CST
