You can configure the e-mail notification setup using sp_lmconfig. Run sp_lmconfig command without any parameters to view the current status and configuration.
To enable e-mail notifications, set the smtp host, smtp port, email sender, email recipients, and email severity properties.
To change the severity that triggers e-mails, set the email
severity property. Values are: "ERROR", "WARNING", "INFORMATIONAL" and "NONE".
To change the list of e-mail recipients, set the email recipients property to the comma separated list of e-mail addresses. E-mail addresses can include distribution lists, e-mail address for a pager device, and anything that is capable of receiving SMTP messages.
