Watches

• A watch identifies a queue or a staging view that is being monitored for errors by a given user. When an error occurs for a queue or a view that is being watched, an email message is sent to the user advising them of the event.

• The email destination user as well as the email message subject and body are predefined during the configuration process.

• Multiple users may watch a given queue or staging view at any time.

The following rules apply to watches:

• If you are watching both a staging queue and a staging view using the same queue, you will only receive a single email message should an error occur.

• The email template for a given queue or staging view must have been defined in the configuration record before you can begin to watch that queue or view.

The following list defines every field available in the watches (md_watch) table in alphabetical order:

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Database Name - this field is maintainable in creation mode only, when it appears in the key subview. The database with which the record being watched is associated.
  • Validated against the databases table.

  • Refer to the Owner Record field description for more details.

• Email Format - the email format for the email message to be sent to the user.
  • Validated against the email formats table.

  • Note: Not updated if the value in the configuration record changes.

• Last Sent Time - this field is not maintainable. The time when the last email message was sent to the user.

• Link Record Edit - this field is not maintainable. An expression column that enables you to go to the owner record directly in edit mode.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Owner Record - this field is maintainable in creation mode only, when it appears in the key subview. The unique identifier associated with the record being watched.
  • This is a string of characters that represents uniquely the primary key in the table referred to by the Table Name and Database Name fields.

• Table Name - this field is maintainable in creation mode only, when it appears in the key subview. The table with which the record being watched is associated.
  • Validated against the tables table.

  • Refer to the Owner Record field description for more details.

• Threshold in Minutes - the duration in minutes after which a new email message can be sent to the user.
  • Default value retrieved from the configuration table.

  • You will not receive another email message until the specified number of minutes has elapsed since the last warning was sent.

• User Name - this field is maintainable in creation mode only, when it appears in the key subview. The user who watches the owner record and who will receive an email message.
  • The unique identifier for a watch in combination with the database name, the table name and the owner record.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.