sql server notification services: How do I get email notification working -- sql server notification services

How do I get email notification working

Bev Kaufman
10/12/2007 1:34:01 PM

sql server notification services:

I have been given the job of database administrator. I very good at SQL
programming, but am just learning about things like backups, replication,
etc. and am VERY shaky on anything involving network administration. I am
not the one who installed Sql 2005 database, so I don't know if any steps
were missed.
Email notification does not work, and I don't know if it ever did. I have
to remember to run a CheckJobs script periodically because the system is not
going to tell me if something goes wrong.
I would like to get this working, but I don't know where to start. The
70-431 Training Kit says that Database Mail must be enabled through the SQL
Server Surface Area Configuration tool, but when I open that up, I have no
idea what I'm supposed to day.
I also went through the Database Mail Configuration Wizard; no error
messages but also no messages coming through my email. When I view the
history, I see a lot of failures, but nothing that tells me why.
How do I fix this?

RE: How do I get email notification working

Bev Kaufman
10/12/2007 1:49:01 PM

This just occurred to me: Could the failure in email notification have any
relation to the fact that I can't set up a linked server to the Sql 2000
Server on my PC? Like maybe fixing one problem will fix both? I was really
surprised when I failed in this simple exercise, since I had no problem
setting up a linked server while working on a client system a couple of years
back. I also bombed in my endpoint exercises, but that's something that's
completely new to me.

[quoted text, click to view]

RE: How do I get email notification working

Todd C
10/19/2007 1:10:01 PM

Bev:
SQL Server Notification Services is pretty far removed from plain old DbMail
in SQL Server 2005. Sounds like you don't need SSNS at all.

Right Click on SQL Agent and select Properties. Go through the tabs. There
is one about Notifications. use the DbMail profile you have setup on the
server.

Now create an Operator with an email address.

For each Agent Job, now, you need to configure the Notification tab to email
the
Operator if the job fails.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.