Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.SCH_W_LOGS_SCHED_JOBS
Table FPSINPUT.SCH_W_LOGS_SCHED_JOBS"
To log sched job
-
Schema: FPSINPUT
-
Tablespace: FPSSCHEDHIST
-
Primary key: JOB_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
JOB_NAME |
VARCHAR2(500) |
N |
the name of the scheduled-job, should also include schema name |
|
LAST_FAIL_INST |
DATE |
when was the last time job ran failed |
|
|
LAST_FAIL_NOTES |
VARCHAR2(4000) |
the notes from the last time job ran failed |
|
|
LAST_SUCCESS_INST |
DATE |
when was the last time job ran successfully |