| OSLOA_OH_Idnr |
int |
NUMBER(38,0) |
int |
int |
false |
ID of the service level objective. |
| OSLOA_MonitorMode |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether the objective is permanently monitored or not. 0 = permanently, 1 = restricted |
| OSLOA_ServQueryDef |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
text |
true |
Output from service query builder. Stored in json or xml format. |
| OSLOA_ConsiderMRT |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether the maximum runtime (MRT) is considered for the fulfillment of the service level objective or not. |
| OSLOA_ConsiderSRT |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether the shortest runtime (SRT) is considered for the fulfillment of the service level objective or not. |
| OSLOA_ConsiderStat |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether the end status of a task is considered for the fulfillment of the service level objective or not. |
| OSLOA_ExpectStatus |
varchar (30) |
VARCHAR2 (30 CHAR) |
varchar(30) |
varchar (30) |
true |
Defines the expected status or status range (e.g. ANY_OK or ENDED_OK). |
| OSLOA_ExeOnFulfill |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates that an object is started if a service level objective is fulfilled. |
| OSLOA_OnFulfilObj |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
varchar (200) |
true |
Object to start if a service level objective is fulfilled. |
| OSLOA_EmlOnFulfill |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates that an email is sent if a service level objective is fulfilled. |
| OSLOA_OnFulfillRcp |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
text |
true |
List of email recipients to inform on fulfillment of the service level objective. Email recipients are separated by ';'. |
| OSLOA_ExeOnViolat |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates that an object is started if a service level objective is violated. |
| OSLOA_OnViloatObj |
varchar (200) |
VARCHAR2 (200 CHAR) |
varchar(200) |
varchar (200) |
true |
Object to start if a service level objective is violated. |
| OSLOA_EmlOnViolat |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates that an email is sent if a service level objective is violated. |
| OSLOA_OnViolatRcp |
varchar(max) |
CLOB |
clob(20480 k) INLINE LENGTH 1024 COMPACT |
text |
true |
List of email recipients to inform on violation of the service level objective. Email recipients are separated by ';'. |
| OSLOA_ConsiderStrt |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not the latest start time is considered for the fulfillment of the service level objective. |
| OSLOA_ConsiderEnd |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
Indicates whether or not the latest end time is considered for the fulfillment of the service level objective. |
| OSLOA_LtstStrtTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
Latest start time. Format: hhmm |
| OSLOA_LtstEndTime |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
Latest end time. Format: hhmm |
| OSLOA_OnWeekdays |
varchar (8) |
VARCHAR2 (8 CHAR) |
varchar(8) |
varchar (8) |
true |
Defines the weekdays the check is active: Format: 1234567 |
| OSLOA_MonitorFrom |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
Start time of monitoring window. Format: hhmm |
| OSLOA_MonitorTo |
varchar (4) |
VARCHAR2 (4 CHAR) |
varchar(4) |
varchar (4) |
true |
End time of monitoring window. Format: hhmm |