Oracledbms_job Oracle10g dbms_scheduler Monitoring Oracle Job Execution scheduled

Our Remote DBA Clients

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 5 - Monitoring Oracle Job Execution

Monitoring Jobs in 10g

Chapter 2 noted that Oracle10g includes a new set of dba_scheduler_% views to display scheduler information. This section will examine the information that can be gathered regarding scheduled jobs using these views and the OEM 10g DB Control.

The list of currently scheduled jobs is displayed using the dba_scheduler_jobs view, which provides list of job names and the basic schedule information. The scheduled_jobs.sql script shows how this view is used.

scheduled_jobs.sql

-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact info@rampant.cc
-- *************************************************

set linesize 200

column owner format a15
column next_run_date format a25

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.