Failover notification through SQL Agent

Question

Is it possible to setup a notification email from SQL agent whenever a failover occured?

THanks

Answer 1

Yes , But on diffferent Server .....

---

Kuldeep

Answer 2

Create a SQL Job which sends email alert when triggered.

Then keep the schedule type as "Start Automatically when SQL Server agent starts".

Now, whenever failover happens sql agent starts automatically which triggers the email alert.

 

Hope this helps.

 

---

- Kerobin

Answer 3

This is the correct approach. I did this a few years ago, but do not have the code. In essence schedule the stored proc to run on startup, but create a stored proc that will read the machine name from the registry, that way you can know exactly which machine is the active node. I would post the code if I could find it, but the description here can get you what you would need.