Re: Scheduled task in Oracle

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)