SQL Instance Cluster Failover Alert

declare @Body nvarchar(128)

select @Body = CONVERT(sysname, SERVERPROPERTY('ServerName')) + ' SQL Agent has failed over to ' + CONVERT(sysname, SERVERPROPERTY('ComputerNamePhysicalNetBIOS'))

EXEC msdb.dbo.sp_send_dbmail

@recipients='test@test.com',

@Body=@Body,

@subject='SQL Instance Cluster Failover Alert'