Supported notification variables
The table below describes which variables can be included in notification messages.
The following variables are not supported even though they are available for selection: ACTIVE_TABLES, ERROR_TABLES , COMMAND, COMMAND_CODE, FULLLOAD_ERROR_TABLES, ERROR_CODE, SQL_STATEMENT, and COMMAND_PARAMETERS.
Variable | Description |
---|---|
LATENCY |
The task latency. For a definition of latency, see Terminology. |
MEMORY_USAGE |
The amount of memory being consumed by all tasks on the Replicate Server machine. |
DISK_USAGE |
The amount of disk space being utilized by the task on the Replicate Server machine. |
COUNT_ERROR_TABLES |
The number of tables in the task with an error status. |
COUNT_ACTIVE_TRANSACTION |
The number of open transactions in the task. |
COUNT_DATA_ERRORS |
The number of data errors encountered by the task. For more information on data errors, see Global error handling |
LOADED_RECORDS |
The number of records loaded to the target database during the task. |
CHANGES_RECORDS |
The number of change records processed during the task. |
FULLLOAD_COUNT_REQUESTED_TABLES |
The number of tables that are queued for loading to the target. |
FULLLOAD_COUNT_COMPLETED_TABLES |
The number of tables that were loaded to the target. |
FULLLOAD_COUNT_ERROR_TABLES |
The number of tables that could not be loaded to the target due to error. |
FULLLOAD_REQUESTED_TABLES_LIST |
The names of the tables that are queued for loading to the target. |
FULLLOAD_COMPLETED_TABLES_LIST |
The names of the tables that were loaded to the target. |
TABLE_NAME |
The name of the table being processed when the notification was sent. |
TABLE_OWNER |
The owner of the table being processed when the notification was sent. |
RECORD_COUNTER |
The number of records that had been processed when the notification was sent. |
ERROR_TEXT |
The error message when a task ends with an error. |
TASK_NAME |
The name of the task. |
NOTIFICATION_NAME |
The name of the notification. |
TABLE_COUNT_APPLY_ERRORS |
The number of tables with Apply Conflict errors. For more information on Apply Conflict errors, see Global error handling |
SERVER_NAME |
The host name of the Replicate Server machine. |
STORAGE_UTILIZATION_OLD_STATE |
The storage utilization state before it moved to the "new" state described below. For a description of possible states, see Define the event that triggers the notification. |
STORAGE_UTILIZATION_NEW_STATE |
The storage utilization state after it moved from the "old" state described above. For a description of possible states, see Define the event that triggers the notification. |
USED_STORAGE_UTILIZATION |
The amount of disk space (on the drive where the Replicate Data folder is located) used by all tasks. |
TOTAL_STORAGE_UTILIZATION |
The total amount of disk space available on the drive where the Replicate Data folder is located. |
TIME_SINCE_LAST_CHANGE | The time that has elapsed in minutes since changes were last captured from the source database. |