14.2 Viewing Scheduled Jobs and Logs

View the status of scheduled jobs and view logs for troubleshooting.

Viewing Scheduled Jobs

To view details and status of the scheduled jobs, connect in SQL*Plus as the OAA schema owner, for example DEV_OAA and run:

SQL> select * from ALL_SCHEDULER_JOBS 

This will give details such as the job name, last run time, time to execute, and next run time.

Vieweing Scheduler Logs

To view the logs from previous jobs, connect in SQL*Plus as the OAA schema owner, for example DEV_OAA and run:

SQL> select * USER_SCHEDULER_JOB_LOG