I'm using a SQL Agent Job with the Schedule: "Start automatically when SQL Server Agent starts"
With the following T-SQL Script
DECLARE @SRV VARCHAR(64)
DECLARE @INST VARCHAR(64)
DECLARE @MBODY VARCHAR(255)
DECLARE @SUBJ VARCHAR(255)
SELECT @SRV=CAST(SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS VARCHAR)
SELECT @INST=@@servername
SET @MBODY = 'Active Node for ' + @INST + ' is ' + @SRV
SET @SUBJ = '!!!ALERT!!! - ' + @SRV + ' restarted'
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'DBMAIL',
@recipients = 'mail@domain.com',
@body = @MBODY,
@subject = @SUBJ;
Bye