- I highly recommend you involve a DBA buddy of yours if you are not familiar with it. I never really used it before starting to setup Orion so it was useful to have someone that could answer questions for me
- Configure Database Mail from the Management options under the DB server
- Expand Databases, NetPerfMon, Programmability. Right clicking on Stored Procedures should allow you to create a new one. Mine’s called EmailUpDownEvents. There is a wizard you can use somewhere for this also.
- The attached file shows the content of the store procedure that you can use. At a minimum, you should be modifying the email address defined as the @recipients. You probably also want to modify the @bodytext and the @profile_name to be whatever you used when configuring Database Mail.
- Execute it so that the stored procedure is created and added to the DB. Refreshing the list of stored procedures should show it there and you should be able to right-click on it and modify it.
- From a query window or a SQL Server Agent Job, you can run “exec EmailUpDownEvents” using the NetPerfMon DB and if it works, you should either get 0 or 1 email regardless of the number of events that have occurred in the past 2 minutes. We have a job scheduled to run it every 2 minutes.
