Re: Looking for Oracle-based Task Schedulers.

lin_h_at_synapse.bms.com (Herng-Chang Lin) wrote:

>Looking for product information of Oracle-based task schedulers
>which utilize timer/clock to schedule database operations (DML,
>DDL, stored procedure, etc.) periodically (eg. every 5 min, every
>hour, daily, weekly, etc.). Both the task programs/commands and
>the scheduling data may be stored in Oracle tables.
>Thanks.

If you have Oracle7.1 or later, you have this already. Look at dbms_job, a supplied package (when used with dbms_sql, can do ddl in the background as well).

If you don't see it in your database, look in $ORACLE_HOME/rdbms/admin for dbmsjob.sql and prvtjob.sql. Run these two and look at the doc in the dbmsjob.sql file.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government Received on Mon Jul 31 1995 - 00:00:00 CEST