You start by creating an alert. To do this, you use the Object Browser to expand the
SQL Server Agent node; then you right-click the
Alerts node and select New Alert. In the Alert Properties dialog that appears (see Figure 12.3), you name the new alert
Database Mail Test Alert and make sure the Enable check box is checked. For the Event type, you leave the selection on SQL Server Event Alert. Under Event Alert Definition, select AdventureWorks2012 from the Database Name drop-down list, and then click the Severity option button and choose 010 - Information. Next, check the Raise Alert When Message Contains check box and type the phrase
This is a Test in the Message Text text box.