Oracledbms_job Oracle10g dbms_scheduler Monitoring Oracle Job Execution jobs_running dba_jobs

Our Remote DBA Clients

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 5 - Monitoring Oracle Job Execution

Monitoring Jobs Prior to 10g

SEE CODE DEPOT FOR FULL SCRIPT
order by
jr.job
;

The type of output that might be expected from this script is listed below.

SQL> @jobs_running

       JOB USERNAME         SID LOCKWAIT   LOGON_TIME
---------- --------- ---------- ---------- --------------------
        42 JOB_USER         265            23-JUN-2004 08:21:25
        99 JOB_USER         272            23-JUN-2004 08:55:35

2 rows selected.

Identifying the sessions that are executing jobs will allow closer monitoring of what the jobs are actually doing.

There is no job history associated with jobs scheduled using the dbms_job package, unlike those scheduled using the dbms_sheduler package in Oracle10g. It is possible to create a job history by mimicking the Oracle10g job history.

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

Need an Oracle Health Check?

Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?

BC Oracle performance guru's can quickly verify every aspect of your Oracle database and provide a complete certification that your database is fully optimized.