Select Notify operators and the checkbox under E-mail next to your operator’s name.Under Event alert definition, in the Severity field, select severity 011.On the General page, give the alert a name of 11 – Specified Database Object Not Found.Right-click Alerts and select New Alert.In SQL Server Management Studio, expand SQL Server Agent (if not still expanded from the previous section).Now it’s time to configure some alert notifications for general error conditions that hopefully will not occur. Maximum job history log size (in rows): 6000.Per the instructions from the installation guide, set the following parameters:.Next to Notify using: select the checkbox for E-mail.The operator you created earlier should already be defaulted if not, select it.Under Fail-safe operator select the checkbox for Enable fail-safe operator.Don’t worry if the Test button is greyed out. In the Mail profile field, select the SID mail profile you configured earlier.Under Mail session select the checkbox for Enable mail profile.
Right-click SQL Server Agent and select Properties.Under Notification options, in the E-mail name field, enter the email address for the system administrator or group distribution list (or yourself) as appropriate.Make sure the Enabled checkbox is checked.
If it’s not a production system, this might be just yourself.
While humming the tune SQL Agent Man to yourself, refer back to your Upgrade to and Installation of SQL Server 2012 in an SAP Environment guide and open it to chapter 5, Setting the SQL Server Agent Configuration. If it worked, click OK on the test popup window.
You should still have your Upgrade to and Installation of SQL Server 2012 in an SAP Environment guide open to chapter 4.2 ( Installing the SQL Server 2012 Database Server Software Manually). SQL Server Post-Install Configuration (Pre-SAP).