zz$scheduler log

From zzat
Jump to: navigation, search

zz$scheduler_log is where zztat archives scheduler logs before purging them.

It has the following columns:

Column Name Data Type Description
zz$db number Database DBID from zz$db
log_date timestamp_with_local_time_zone Timestamp from the scheduler tables.
job_name varchar2 Name of the job.
status varchar2 Status from the scheduler tables.
error# number Returncode from the scheduler tables.
req_start_date timestamp_with_local_time_zone Taken from the scheduler tables.
actual_start_date timestamp_with_local_time_zone Taken from the scheduler tables.
errors varchar2 Taken from the scheduler tables.