rs_operator_messages
The following table lists the columns for the rs_operator_messages view. The equivalent jcs_operator_messages view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| JOB_ID | NUMBER | The unique id of a job (if message is job-related) |
| TYPE | VARCHAR2 | The type of message: M=Message without requiring a reply, A=Message requiring a reply, |
| SEQNO | NUMBER | The sequence number of the operator message |
| TEXT | VARCHAR2 | The text of the message |
| DATA_TYPE | VARCHAR2 | The required data type of the reply |
| ANSWER_VARCHAR2 | VARCHAR2 | The default value provided for a varchar2-reply |
| ANSWER_DATE | TIMESTAMP | The default value provided for a date-reply |
| ANSWER_NUMBER | NUMBER | The default value provided for a number-reply |
| INPUT_FORMAT | VARCHAR2 | The input format for the reply |
| CHECK_STRING | VARCHAR2 | The SQL-check for the reply |
| CTIME | TIMESTAMP WITH TIME ZONE | The date and time the message was createdThe timezone is specified as an Olson name. |
| CTIME_SORT | NUMBER | The date and time the message was created as number (has Oracle index) |
| ATIME | TIMESTAMP WITH TIME ZONE | The date and time the message was answered or the job was abortedThe timezone is specified as an Olson name. |
| CREATOR_AUDSID | NUMBER | The audit identification of the user creating the message |
| CREATOR_USER | VARCHAR2 | The user creating the message |
| CREATOR_MACHINE | VARCHAR2 | The machine of the user creating the message |
| ANSWER_AUDSID | NUMBER | The audit identification of the user answering the message |
| ANSWER_USER | VARCHAR2 | The user answering the message |
| ANSWER_MACHINE | VARCHAR2 | The machine of the user answering the message |
| MONITOR_ID | NUMBER | The monitor id of the condition that created the alert |
| ETIME | TIMESTAMP WITH TIME ZONE | The endtime of the alertThe timezone is specified as an Olson name. |
| SEVERITY | NUMBER | The severity of the alert |
| CONFIRMED | VARCHAR2 | Is the alert confirmed |
note
TYPE: M = Message, A = a question to be answered, null = an answered question
note
TEXT: This is only the first 2000 characters of the complete text
note
DATA_TYPE: In version 9, only VARCHAR2/String operator messages are allowed.
note
ANSWER_NUMBER: Always empty, because in version 9, only VARCHAR2/String operator messages are allowed.
note
CHECK_STRING: Where this was a PL/SQL expression in version 7 or before, it is now a regular expression
note
INPUT_FORMAT: Input format is not supported in version 9
note
CREATOR_AUDSID: This column is not supported in version 9
note
CREATOR_USER: Instead of the creator, this now returns the user that last changed the operator message
note
CREATOR_MACHINE: This column is not supported in version 9
note
ANSWER_AUDSID: This column is not supported in version 9
note
ANSWER_MACHINE: This column is not supported in version 9
note
MONITOR_ID: This column is not supported yet
note
ETIME: This column is not supported yet
note
SEVERITY: This column is not supported yet
note
CONFIRMED: This column is not supported yet
plsqlTopic
onsiteTopic