Db Maint SMTP Alerter

Home About me and Nucleus Partners Articles, tips etc. My blog Links Microsoft articles Forums Course demo files

Event alerts using SMTP instead of MAPI. No Outlook needed. SQL Server Agent can be configured to notify an operator when certain error messages has been written to the eventlog by SQL Server. Unfortunately, this is based on MAPI (SQL Server 2005 has SMTP support), and installing and getting MAPI to functioning properly for SQL Server and SQL Server Agent can be a mess. We already have a substitute for the MAPI based xp_sendmail: xp_smtp_sendmail from SQLDev.Net (home page). The Db Maint SMTP alerter allow you to be notified using SMTP (using xp_smtp_sendmail) instead of MAPI. This mean that you do not have to install Outlook and configure MAPI on your SQL Server. Important notice: Since SQL Server 2005 comes with built-in SMTP support ("Database Mail"), usable directly from Agent, I suggest using Database Mail instead. We do not have the resources to offer support on the SMTP Alerter. The source code is available, however. Instructions: Download and install xp_smtp_sendmail from SQLDev.Net. Download the files for Db Maint SMTP Alerter. There is no installation program, just download the zip file, create a directory and extract the files to this directory. Use Enterprise Manager to create the operators. Specify an email address for each operator. Important: Disable each operator. If you don't disable the operators, then SQL Server Agent will also try to send mail to them and write failure messages tn the eventlog. Create the desired alerts in Enterprise Manager. For each alert, specify the operator(s) you want to be notified. Run the client (DbMAlerterClient.exe) to create the needed tables in msdb, and also configure the SMTP mail settings. Schedule the server (DbMAlerterServer.exe), which will read the eventlog and submit email to the operators as configured. Recommended scheduling interval is between once per minute to once per 10 minutes. DbMAlerterServer.exe will attempt to login to the SQL Server using Windows logins and it takes one command-line parameter: the name of the SQL Server to connect to, as in C:\Program Files\DbMaintSmtpAlerter\DbMAlerterServer MachineName[\InstanceName] Download Db Maint SMTP Alerter executable DbMaintAlerter.zip Download Db Maint SMTP Alerter source code (VS 2003, VB, FX 1.1) DbMaintAlert.zip If you feel like maintaining an site with updated versions of the SMTP Alerter, feel free to. I suggest you drop me an email so I can link to it from this page. Prerequisites: .NET framework 1.1 or later. It is likely that this already is installed on your machine, if not you will get an error message that the application failed to initialize. You can install the framework using Windows Update, or download it from microsoft (search for "framework redistributable" at http://www.microsoft.com/downloads). Xp_smtp_sendmail which you can find at SQLDev.Net., where you also find download and installation instructions. Limitations: Supports only one operator. Only the first operator for the alert will receive email. Only support installations where SQL Server writes the error messages in the default English language. Will not perform NET SEND. If you want net send alerting, create an operator for the net send, do not disable this operator and specify this operator as well for the alert; with net send notification (just as a regular Agent notification). If NonAlertableErrors has been configured in the registry and such are encountered, the email will not be submitted (just as Agent does it). However, a warning will not be written to the event log when this happens. Db Maint home page: This is a free utility from Db Maint: www.dbmaint.com.