data-dictionary

FPSBASE.ADM_SCHEDULER_JOB_LOG

Data Dictionary

>

FPSBASE Views

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.ADM_SCHEDULER_JOB_LOG

Oracle provides both DBA_SCHEDULER_JOB_LOG and DBA_SCHEDULER_JOB_RUN_DETAILS. The latter provides more detail so we use that one but we like the shorter name of the former.

Column

Comment

DURATION_SEC

Duration in seconds of the period to be used to run the APF report. Used only for CLR, CLRA, and QE. (* inherited from FPSADMIN.CFG_TABLES)

LOG_DATE

OWNER

JOB_NAME

the name of the scheduled-job, should also include schema name (* inherited from FPSAPP.SCH_W_LOGS_SCHED_JOBS)

STATUS

REQ_START_DATE

ACTUAL_START_DATE

SESSION_ID