 |
|
Oracle Tips by Burleson |
Chapter 5 -
Monitoring Oracle Job Execution
Monitoring Jobs Prior to
10g
To do this, schema objects must be created to hold the history
records. This achieved by using the job_run_details_schema.sql script as shown below.
job_run_details_schema.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
--
*************************************************
conn sys/password as sysdba
grant select on v_$session to job_user;
grant select on dba_jobs_running to job_user;
grant select on v_$sesstat to job_user;
grant select on v_$statname to job_user;
conn job_user/job_user
create table job_run_details (
log_id NUMBER,
log_date DATE,
owner VARCHAR2(30),
job NUMBER,
status VARCHAR2(30),
error# NUMBER,
|
|
|
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. |
|
|
