Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to create a stored procedure for logging messages to Windows Application Event Viewer:

Use AdventureWorks
Go

Create Procedure LogInfoToEventViewer @MessageText varchar(1000)
As
Begin

Exec master..xp_logevent 50001, @MessageText, INFORMATIONAL

End
Go

Exec LogInfoToEventViewer 'Evening batch job FinanceEOD executed successfully'
Go