Query to Check the Default Automatic Maintenance Jobs in Oracle

 

To Check Job Run History on 11g:
SELECT * FROM DBA_AUTOTASK_CLIENT_HISTORY;

To Check Job Run History on 10g or 11g:
SELECT *
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE OWNER = 'SYS'
ORDER BY ACTUAL_START_DATE DESC;

To Check if Automatic Maintenance jobs are enabled:
SELECT JOB_NAME,
SCHEDULE_NAME,
SCHEDULE_TYPE,
ENABLED,
LAST_RUN_DURATION,
LAST_START_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER = 'SYS';

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

About Jimbart