It’s possible to send messages from one system to another system in an Intranet by using ‘xp_cmdshell’ extended stored procedure in MS SQL Server. The usage of this procedure can be as follows:
Exec master..xp_cmdshell 'NET SEND
message'Ex: exec master..xp_cmdshell 'NET SEND prodmaster Hi, How R U?'
Note: The messenger service also needs to be started in the destination system. If messenger service is stopped the above command will not work.