To monitor alertsWhenever a server is configured as a Distributor, the following predefined alert response jobs are installed.
| Predefined response job |
Responds to alert |
Action |
|---|---|---|
| Reinitialize subscriptions on data validation failure | Replication: Subscriber has failed data validation. | Reinitializes all subscriptions that have logged a sysreplicationalerts record with alert_error_code = 20574.
If a transactional publication, only articles that failed are reinitialized. If a merge publication, the whole publication is reinitialized. |
Note The response jobs included in Microsoft® SQL Server™ are provided only for the most well-known responses and as examples you can use for writing your own response jobs. The provided response jobs are not associated with an alert after they have been installed. You must configure an alert manually to call the appropriate response job.
To monitor alerts
| SQLServerAgent Service | Monitoring Data Validity |