Oracledbms_job Oracle10g dbms_scheduler Monitoring Oracle Job Execution scheduled_jobs dba

Our Remote DBA Clients

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 5 - Monitoring Oracle Job Execution

Monitoring Jobs in 10g

select
   job_name,
   owner,
   nvl(to_char(next_run_date, 'DD-MON-YYYY HH24:MI:SS'), schedule_name) as
next_run_date,
   to_char(last_start_date, 'DD-MON-YYYY HH24:MI:SS') as last_run_date,
   job_class,'
   run_count
from
   dba_scheduler_jobs
;

The output generated from the scheduled_jobs.sql script is shown below.

SQL> @scheduled_jobs

JOB_NAME  OWNER                NEXT_RUN_DATE   LAST_RUN_DATE
JOB_CLASS            RUN_COUNT
------------------------------ --------------- ------------------------- -------------------- ------------------------------ ----------
GATHER_STATS_JOB               SYS             MAINTENANCE_WINDOW_GROUP 24-JUN-2004 08:09:39 AUTO_TASKS_JOB_CLASS                    4
PURGE_LOG                      SYS             24-JUN-2004 03:00:00      23-JUN-2004 03:00:01 DEFAULT_JOB_CLASS                      19
TEST_FULL_JOB_DEFINITION       JOB_USER        24-JUN-2004 08:52:00      24-JUN-2004 08:52:00 DEFAULT_JOB_CLASS                     281
TEST_PROG_SCHED_CLASS_JOB_DEF JOB_USER        24-JUN-2004 09:00:16      24-JUN-2004 08:09:39 TEST_JOB_CLASS                         16
ARGUMENT_JOB_DEFINITION        JOB_USER        24-JUN-2004 09:00:16      24-JUN-2004 08:09:39 DEFAULT_JOB_CLASS                      16
TEST_SCHED_JOB_DEFINITION      JOB_USER        24-JUN-2004 09:00:16      24-JUN-2004 08:09:37 DEFAULT_JOB_CLASS                      16
TEST_PROG_JOB_DEFINITION       JOB_USER        24-JUN-2004 09:00:09      24-JUN-2004 08:09:38 DEFAULT_JOB_CLASS                      16
TEST_PROG_SCHED_JOB_DEFINITION JOB_USER        24-JUN-2004 09:00:16      24-JUN-2004 08:09:39 TEST_JOB_CLASS                         16

8 rows selected.

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.