Use sp_lmconfig to configure e-mail notification. To view the current notification status and configuration, execute sp_lmconfig without any parameters.
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-mail notification, set the email severity property to: "ERROR", "WARNING", "INFORMATIONAL", or "NONE".
To change the list of e-mail recipients, set the email recipients property to a comma-separated list of e-mail addresses. E-mail addresses can include anything that is capable of receiving SMTP messages.