Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.SCH_W_LOGS_SCHED_JOBS
Table FPSADMIN.SCH_W_LOGS_SCHED_JOBS"
To log sched job
-
Schema: FPSADMIN
-
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 |