SQL Server cluster node fail over details 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?
Thank you.
Just to add, your sql agent job could look like this, which works for us (this assumes you have database mail configured properly):
Set the schedule to be when sql server starts as described in Ronaldo's answer
DECLARE @importance AS VARCHAR(6)
DECLARE @body AS NVARCHAR(1000)
DECLARE @Subject  AS NVARCHAR(1000)
DECLARE @InstanceName AS VARCHAR(100)
DECLARE @NodeName AS NVARCHAR(100)
DECLARE @recipientsList VARCHAR(100)

SELECT  @recipientsList ='someuser@mycompany.com;someuser@mycompany.com'
SELECT  @InstanceName =@@SERVERNAME
SELECT  @NodeName = CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NVARCHAR(200))
SELECT  @Subject  = 'Failover occured for SQL Server Instance '+@InstanceName
SELECT  @body = 'Failover occured for SQL Server Instance '+@InstanceName + 'This instance is currently running on the node '+@NodeName
SELECT  @importance ='High' 
EXEC msdb.dbo.sp_send_dbmail 
     @profile_name ='Dbas',
     @recipients=@recipientsList,
     @subject = @subject ,
     @body = @body,
     @body_format = 'HTML' ,
     @importance = 'HIGH'