Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How do I get email notification working

 
   Database Forums (Home) -> Notification Services RSS
Next:  Infinite recursion detected  
Author Message
Bev Kaufman

External


Since: Jul 11, 2007
Posts: 11



(Msg. 1) Posted: Fri Oct 12, 2007 1:34 pm
Post subject: How do I get email notification working
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

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?

 >> Stay informed about: How do I get email notification working 
Back to top
Login to vote
Bev Kaufman

External


Since: Jul 11, 2007
Posts: 11



(Msg. 2) Posted: Fri Oct 12, 2007 1:49 pm
Post subject: RE: How do I get email notification working [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

 >> Stay informed about: How do I get email notification working 
Back to top
Login to vote
Todd C

External


Since: Nov 16, 2005
Posts: 110



(Msg. 3) Posted: Fri Oct 19, 2007 1:10 pm
Post subject: RE: How do I get email notification working [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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]


"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?
> >
 >> Stay informed about: How do I get email notification working 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
database 'DBNAME' is not enabled for SQL cache notification - I'm getting this message on SqlCacheDependencyAdmin.EnableTableForNotifications and aspnet_regsql.exe -C connstr -lt Yet, the following execution has finished successfully: ALTER DATABASE dbname SET ENABLE_BROKER

Email-NS - Hi All, I am very much new to Notification Services. I have to perform a task like when ever there is some updations in one of my DB tables i have to get some Alerts like an email. Then i came accross this Notification services. But i dont know to..

NS & Email - what am I doing wrong? - OK - new guy here - following the tutorials, I've modified them to reflect my application's basic needs, and the notifications are coming to the htm file fine. I've now added a delivery channel, and updated myself (the only subscriber) and my device to....

backup job email notification - Hi all, I'm new to SQL and setup a backup job. I setup my internet email address as the person to notify when back completes. When I do the test I get the following error: Error 22022 SQLServer Agent Error: THe SQLserveragent mail session is not ..

How to configure email notification? - Dear all, I am not sure if I am posting my question at the right place. Anyway, I hope someone can help me out. I have a scheduled job in SQL server agent and I would like to configure the email notification if the job fails. When I tried to create a....
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]