Re: [Q] Oracle scheduler???

In article <e_keen.795365243_at_access4>, e_keen_at_access4.digex.net (Eric Keen) writes:
> rmanalac_at_us.oracle.com (Roderick Manalac) writes:
.
.
>
> >Eventually, in Oracle7.2 there will be a DBMS_JOB package to execute
> >stored procedures at a certain time (and interval). However, this
> >will probably only allow you to run jobs within the RDBMS itself. If
> >you want a generated report written out to a file, you will have to
> >fallback to having a cron-like job run an application at the OS level.
 

> >Roderick Manalac
> >Oracle Corporation
> >DISCLAIMER: Implied.
>
> Actually, the stuff is in Oracle 7.1.3 but not documented.
>
> Check out $ORACLE_HOME/rdbms/admin/dbmsjob.sql
>
>

The package is actually operational and is installed with 7.1's catproc.sql Very nice stuff.

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-2536173
 \_______/                  |Email:TJambu_at_wizard.com.au PHONE: +61-3-2536385