10 February 2014

When a database failover occurs, send an email on event id

When a database failover occurs you normally wouldn't know unless you have a monitoring like SCOM setup.
In our case we don't have any kind of monitoring going on, but i do want to know if a failover occurs.

To do this we can use the great new feature of the eventviewer: "Attach task to this event".
The events you're looking for are:

127
147
161
184
184
252
292
293
301
316
333

After filtering the eventlog in: applications and services logs - microsoft - exchange - high availability - operational filter the log on warnings, errors, and critical events, you can see all failover related event id's.


Select an event and click "Attach task to this event".



Select "Send an e-mail"


Fill out with your settings


On the summary page you can select "Open the properties dialog for this task when i click finish", this allows you to change the account the the task uses to run.


After you click finish the task can be found at "event viewer tasks"


When any of these events occurs, you will be notified.
You will have to do this for every event you want to monitor.

No comments:

Post a Comment