IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home > Collecting database statistics > Gathering statistics with gather_and_lock_stats_job
Occasionally, dbms_scheduler jobs fail. Use this procedure to view only the failed jobs and sort them according start date.
To check for failed dbms_scheduler jobs
Login as user oracle on AS3000 or AgfaService on AS300 Oracle on Windows.
To login to sqlplus, type
sqlplus / as sysdba
Run the following command:
select log_date, job_name, status, req_start_date, actual_start_date, run_duration from dba_scheduler_job_run_details where status <> 'SUCCEEDED' order by actual_start_date;
To logout of sqlplus, type
exit
Topic number: 113633 Applies to: IMPAX 6.5.1 Server Knowledge Base |