Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.SCH_C_CFG_SCHED_JOBS
Table FPSADMIN.SCH_C_CFG_SCHED_JOBS"
To configure how to run sched job
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: JOB_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
JOB_NAME |
VARCHAR2(500) |
N |
the name of the scheduled-job, should also include schema name |
|
ALERT_SEC |
NUMBER |
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. (* from FPSINPUT.RTG_SCHED_GROUPS) |
|
|
IS_ACTIVE |
CHAR(1) |
Flag to enable or disable the tag condition. (* from FPSBASE.MSO_TAG_CONDITIONS) |
|
|
JOB_GROUP |
VARCHAR2(50) |
N |
To indicate which group. for first version, it will only allow REALTIME, 10MIN, SHIFT |