[Top] [All Lists]

RE: How do I get email notification working

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