Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSAPP.SCH_P_CFG_SCHED_JOBS
the list jobs scheduled to run
|
Column |
Comment |
|---|---|
|
JOB_GROUP |
To indicate which group. for first version, it will only allow REALTIME, 10MIN, SHIFT (* inherited from FPSAPP.SCH_C_CFG_SCHED_JOBS) |
|
JOB_NAME |
the name of the scheduled-job, should also include schema name (* inherited from FPSAPP.SCH_W_LOGS_SCHED_JOBS) |
|
JOB_ORDER |
|
|
IS_ACTIVE |
Flag to enable or disable the tag condition. (* inherited from FPSBASE.MSO_TAG_CONDITIONS) |
|
ALERT_SEC |
This column is used to determine how long the SysMonitor (Health Check Alert Application) will wait (since last successful run) before issuing an alert and sending text message or email to the recipients. (* inherited from FPSINPUT.RTG_SCHED_GROUPS) |
|
LAST_SUCCESS_INST |
when was the last time job ran successfully (* inherited from FPSAPP.SCH_W_LOGS_SCHED_JOBS) |
|
LAST_SUCCESS_RUN_TIME |
|
|
LAST_FAIL_INST |
when was the last time job ran failed (* inherited from FPSAPP.SCH_W_LOGS_SCHED_JOBS) |
|
LAST_FAIL_NOTES |
the notes from the last time job ran failed (* inherited from FPSAPP.SCH_W_LOGS_SCHED_JOBS) |
|
SHOULD_ALERT |
|
|
ALERT_NOTES |