Regarding database mail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Iter - 24 Jan 2008 20:44 GMT

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.

Reply to this Message

Ekrem Önsoy - 25 Jan 2008 09:14 GMT

SQL Server 2005 Database Mail works just fine. If your SQL Server 2005
Edition is > "Express Edition" then give Database Mail a chance.

- First enable Database Mail from SQL Server Surface Area Configuration tool
if you have not.
- Configure a mail profile and account in Database Mail,
- Enable your mail profile from SQL Server Agent' s properties\Alert System
- Create an Operator (under SQL Server Agent node)
- Configure the job which is supposed to send an alert (from its
properties\Notifications)

I have a step by step article about this, but it's in Turkish.

Signature

Ekrem Önsoy

> Hi guys,
> I am thinking about how to setup alert and database mail. In the compamy,
[quoted text clipped - 3 lines]
> I
> use sql server build in alert and database mail? Thanks.

Reply to this Message

Iter - 25 Jan 2008 14:24 GMT

Thank you very much. I cannot read it in Turkish. Do you have plan to
translate to English? Thanks.

> SQL Server 2005 Database Mail works just fine. If your SQL Server 2005
> Edition is > "Express Edition" then give Database Mail a chance.
[quoted text clipped - 16 lines]
> > I
> > use sql server build in alert and database mail? Thanks.

Reply to this Message

Ekrem Önsoy - 25 Jan 2008 19:32 GMT

Nope, sorry. I publish them only in Turkish because there is already enough
material in English.

Google for it. Some links for DB Mail Conf.:
http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql
2005/2197/

http://www.mssqltips.com/tip.asp?tip=1100

Signature

Ekrem Önsoy

> Thank you very much. I cannot read it in Turkish. Do you have plan to
> translate to English? Thanks.
[quoted text clipped - 23 lines]
>> > I
>> > use sql server build in alert and database mail? Thanks.

Reply to this Message