To define alerts, you select the
SQL Server Agent node in the Object Explorer tree and then right-click on the
Alerts node and select New Alert. Figure 13.16 shows an example of the New Alert dialog that appears.
The General page selected in Figure 13.16 allows you to define the basic alert properties, including the name of the alert and type of event you want the alert to respond to. The default type of alert, the SQL Server event alert, is triggered by SQL Server events that write to the Windows Application event log. SQL Server writes to the Application event ...