Create a SQL Server Database Alert
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
You can use System Monitor to create an alert that is raised when a threshold value for a System Monitor counter has been reached. In response to the alert, System Monitor launches an application, such as a custom application written to handle the alert condition. For example, you could create an alert that is raised when the number of deadlocks exceeds a specific value.
Alerts also can be defined by using SQL Server Management Studio and SQL Server Agent. For more information, see Alerts.
For more information about using System Monitor to set up a SQL Server database alert, see Set Up a SQL Server Database Alert (Windows) .