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