12 Maret 2011 1:15
Is it possible to setup a notification email from SQL agent whenever a failover occured?
08 Juli 2011 10:11Yes , But on diffferent Server .....
09 Agustus 2011 5:21
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.
- Disarankan sebagai Jawaban oleh KEROBIN 17 Agustus 2011 18:23
21 Nopember 2011 17:57This 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.