Data Dictionary
>
FPSAPP Tables
> FPSAPP.SYSMNTR_C_CHECKS
Table FPSAPP.SYSMNTR_C_CHECKS"
In this table, we set specific configurations for various checks based on view_name. Records in this table are optional and all SYSMNTR_P_CHK views will appear in SYSMNTR_P_CHECKS. The view has default configuration to use in the case that no record exists in this table.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
VIEW_NAME |
VARCHAR2(30) |
The name of the view uses for this check which starts with SYSMNTR_P_CHK. |
|
|
ALERT_INTERVAL_MINS |
NUMBER(4) |
N |
This is the interval in minutes between email alerts. It is normal for this to be larger than the check interval which means the web page is updated but we do not bombard everyone with alerts. |
|
CHECK_INTERVAL_MINS |
NUMBER(4) |
N |
This is the interval in minutes between calls to the view to check the status. The web page is always updated immediately after each call. |
|
DESCRIPTION |
VARCHAR2(256) |
A description of the check which is displayed on the System Monitor web page and in email notifications. |
|
|
EMAIL_LIST |
VARCHAR2(1000) |
N |
This field can contain on or more email addresses separated by spaces. To send text messages you enter the mobile phone number in email format which is dependent on the phone service provider. |
|
WHY_ALERT_DISABLED |
VARCHAR2(256) |
Any value is this field will disable sending email alerts for this check but please write the reason why it is disabled even if this is temporary. |