Server Alert Properties Dialog

This dialog allows you to set up email alerts for specific events that occur at the server level. Use the Alert Settings tab to choose which events to include in an email, and use the Message Layout tab to specify email recipients and email content. In addition to defining the email content in this dialog, you must set email server properties in the Mail tab of the Replication Agent Options dialog.

As an alternative, or in addition to email alerts at the server level, you can set up email alerts for a specific replication using the Alerts tab in the Replication Properties dialog.

Note: It is also possible to create a custom email alert by writing a script that uses the SendMail function.

Event Alerts

To define email alert messages for specific Replication Agent or replication events, on the Replication Agent Options dialog Alerts tab, click Add Alert, then Add Event Alert to display the Server Alert Properties - Event Alert screen. In the Alert Settings tab, select the event or events for which you want to receive an email message, then use the Message Layout tab to define the email format. Finally, set up the email server details in the Replication Agent Options Mail tab.

Filtering Alerts

Where the alert type allows, it is possible to set a filter to identify specific conditions for an alert. The filter field is displayed to the right of the alert name and can contain logical operators in addition to specific strings. The supported logical operators are AND, OR, NOT (uppercase with precedence as shown). Parentheses can be used to change operator precedence. Substrings to be matched with message content should be enclosed in quotes (') or double quotes(").

Examples:

All messages for enabled replications except "EMP50" and "EMP51":
"enabled" AND NOT ("EMP50" OR "EMP51")
All messages not containing the substring "warning 256":
NOT "warning 256"
All messages containing "error" or "warning":
"error" OR "warning"

Alert Settings Tab

Server Events
Start Replication Agent	Reports when the Replication Agent starts.
Stop Replication Agent	Reports when the Replication Agent stops.
Reached Max Quota for Traces	Sets a maximum trace file size after which you want to be notified. For example, if the trace file size is set to 100 MB, an email would be sent once the 100 MB limit is reached.
Reached Max Replication Agent Downtime	Sets a maximum number of hours that the Replication Agent could be stopped before sending an email notification. For example, if the number of hours is set at 3, an email would be send once the down time reaches 3 hours.
Replication Agent Info	Reports all comments generated by Syniti DR in the Replication Agent "Information" category. The filter option allows you to set a string to identify a subset of "Information" messages you want to receive.
Replication Agent Error	Reports all comments generated by Syniti DR in the Replication Agent "Error" category. The filter option allows you to set a string to identify a subset of "Error" messages you want to receive.
Replication Agent Warning	Reports all comments generated by Syniti DR in the Replication Agent "Warning" category. The filter option allows you to set a string to identify a subset of "Warning" messages you want to receive.
Replication Events
Replication Info	Reports all comments generated by Syniti DR in the "Information" category for each replication. The filter option allows you to set a string to identify a subset of "Information" messages you want to receive.
Replication Errors	Reports all comments generated by Syniti DR in the "Error" category for each replication. The filter option allows you to set a string to identify a subset of "Error" messages you want to receive.
Replication Warnings	Reports all comments generated by Syniti DR in the "Warning" category for each replication. The filter option allows you to set a string to identify a subset of "Warning" messages you want to receive.
Reached Max Replication Latency	Check this option to report when the Transaction Latency Thresholdsetting in the General tab of the Replication Agent Options dialog has been exceeded by comparing the current time with the latest processed transaction time (or the last scheduled mirroring time if there are no transactions) for the replication. If the lag between the two exceeds the Transaction Latency Threshold (set in the General tab of the Replication Agent Options dialog), an email message is generated. This can indicate that the current settings for the Replication Agent and the replication are not allowing the Replication Agent to keep up with the number of transactions. If the filter field is empty, all replications activate an alert. Set a filter of one or more replication names (logic operators such as AND OR NOT are supported) to activate the alert on the filter only.
Reached Max Replication Downtime	Check this option to set a maximum number of hours that the replication can be stopped before sending an email notification. For example, if the number of hours is set at 3, an email would be send once the down time for any replication reaches 3 hours. If the filter field is empty, all replications activate an alert. Set a filter of one or more replication names (logic operators such as AND OR NOT are supported) to activate the alert on the filter only.
Verifier Differences	Check this option to report details of all differences detected when comparing source and target replication results. If the filter field is empty, all replications activate an alert. Set a filter of one or more replication names (logic operators such as AND OR NOT are supported) to activate the alert on the filter only.

Alert Schedule

Use this option to limit the number of email messages you receive for a defined set of alerts.

Message Layout Tab

Use this tab to define the alert email recipients and the overall layout of the email message

Recipients

A semi-colon separated list of email addresses

Title

A default email subject line is provided, but you can edit the text to provide your own subject line.

Body

A default email body format is provided, but you can edit the text to customize the email format.

Html Format
Check this option to send email messages in HTML format.

Attachment
To attach the current text file log to the email, select Log from the drop-down list.

Activity Report

Use the AddActivity Report option to create general email message alerts for Replication Agent activity in the Server Alert Properties dialog. On the Replication Agent Options dialog Alerts tab, click Add Alert, then Add Activity Report to display the Server Alert Properties - Activity Report screen. In the Alert Settings tab, choose how often you want to receive an email message, then use the Message Layout tab to define the email format. Finally, set up the email server details in the Replication Agent Options Mail tab.

Opening the Server Alert Properties Dialog

In the Management Center Metadata Explorer, select a server (usually local). From the right mouse button menu, choose Replication Agent Options. In the Replication Agent Options dialog, go to the Alerts tab. Click Add Alert then either Add Event Alert or Add Activity Report to open the Server Alert Properties dialog.