From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Configure job alerts and notifications

Configure job alerts and notifications

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure job alerts and notifications

“

- Welcome back. This is lesson 10.2: Configure job alerts and notifications. The last video, we talked about the different components in which to define and configure a SQL Server Agent job. One of those was the job alerts. An alert is in response to a specific event such as a SQL Server event or in reaction to a SQL Server performance condition. When an alert occurs, the alert can perform a couple of actions including the notification of an operator and the execution of a different job. Creating an alert is done by selecting the alerts page on the job properties and clicking add to add a new alert. There are three types of alerts: SQL Server event alerts, performance condition alerts, and WMI alerts. For SQL Server event alerts, you can specify an alert to occur in response to an event such as when a SQL Server severity error occurs. A good example of this is severity errors 19 through 25, which alert on fatal errors such as when SQL Server detects a database integrity issue, for…

Contents