[Top] [All Lists]

RE: How do I get email notification working

Subject: RE: How do I get email notification working
From: Todd C
Date: Fri, 19 Oct 2007 13:10:01 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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.

Todd C

[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?
> > 

<Prev in Thread] Current Thread [Next in Thread>