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
Now create an Operator with an email address.
For each Agent Job, now, you need to configure the Notification tab to email
Operator if the job fails.
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]
"Bev Kaufman" wrote:
> 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.
> "Bev Kaufman" wrote:
> > 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?