January 24, 2008 at 2:05 pm
Hi guys,
I am thinking about how to setup alert and database mail. In the compamy,
what kind of tool can we use for sending alert and database mail? use third
party tools or microsoft sql server build in tools? Is that good to use if I
use sql server build in alert and database mail? Thanks.
January 24, 2008 at 2:21 pm
I've used the built in alert / database mail in SQL2005 for quite awhile and it has always worked fine for me. I've never used anything but e-mail as the alert (it does things like page and net send also I believe).
The only gripe I have for the e-mail alerts for job failures is you can only alert one e-mail address.
The Redneck DBA
January 24, 2008 at 4:56 pm
Jason Shadonix (1/24/2008)
I've used the built in alert / database mail in SQL2005 for quite awhile and it has always worked fine for me. I've never used anything but e-mail as the alert (it does things like page and net send also I believe).The only gripe I have for the e-mail alerts for job failures is you can only alert one e-mail address.
Jason, why not setup an operator that is multiple emails addresses then alert that operator, or, email a distribution list from your alerts.
January 24, 2008 at 5:30 pm
E-mailing a distribution list is definatly a solution if you can convince your mail administrators to set it up for you.
Can you have an operator with more than one e-mail? If so, then you could do that also...how do you do that?
The Redneck DBA
January 24, 2008 at 5:33 pm
Jason Shadonix (1/24/2008)
E-mailing a distribution list is definatly a solution if you can convince your mail administrators to set it up for you.Can you have an operator with more than one e-mail? If so, then you could do that also...how do you do that?
ahh good old email admins eh! To add multiple email addresses to an operator just add a semi colon between the email addresses. you can normally add about 3 or 4 before the text becomes too long, then its a time for a distribution group.
January 24, 2008 at 5:38 pm
Clever! It would be nice if the documentation on creating an operator mentioned that you could have more than one address in there...it never occured to me to try that.
Thanks!
The Redneck DBA
January 24, 2008 at 5:41 pm
Jason Shadonix (1/24/2008)
E-mailing a distribution list is definatly a solution if you can convince your mail administrators to set it up for you.Can you have an operator with more than one e-mail? If so, then you could do that also...how do you do that?
You can have an Operator setup with more than one email address:
dba1@mydomain.com; dba2@mydomain.com; dba3@mydomain.com
The table column that holds the operator email address is fairly short, but you should be able to get 3 or 4 email addresses for one operator.
You can also sent email alerts to 2 different operators for one job by defining a page email address for an operator, and sending a page alert to that operator.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply