Oracledbms_job Oracle10g dbms

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Overview and Examples of dbms_job Functions

COLUMN job FORMAT 999
COLUMN what FORMAT A55
COLUMN interval FORMAT A30

select
   job,
   what,
   next_date,
   interval
from
   user_jobs
SEE CODE DEPOT FOR FULL SCRIPT
order by
   next_date
;

The output generated by the jobs.sql script is displayed below.

SQL> @jobs job_user

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books