I would like to know the SQL Server cluster node fail over details immediately as soon as the passive node is active as I have some dependency on active node. For that, I see
sys.dm_os_cluster_nodes view will provide the active/passive node details, but I am not able to write a trigger on this view to send a mail automatically.
I spent some time but was not able to find out. I can write a SQL Server job to monitor but I will not prefer that.
Could you please help in guiding me to get a notification mail once the active node becomes passive?