Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster (twice).
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, sent myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I would check 2 things:
In Surface Configuration, is Database mail enabled
When you used the wizard to setup database mail, you had to create a
profle. Is that profile set as the "default"?
tootsuite@.gmail.com wrote:
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
|||If you are installed on a 64-bit platform, you will need to continue to use
SQL Mail and Outlook Express as your SMTP client.
How to configure SQL Server Agent to send job status notifications and alert
notifications in SQL Server 2005 64-bit editions
http://support.microsoft.com/kb/908360
Anthony Thomas

<tootsuite@.gmail.com> wrote in message
news:1162832443.165881.76790@.i42g2000cwa.googlegro ups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster (twice).
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, sent myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>

Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
Thanks
I have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegr oups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>

Email notification does not send

Hello,
re: SQL Server 2005, SP1
I set up Database Mail on a clustered server using the db mail wizard
in Management Studio. I set up an operator using a mail group. The test
email worked fine. I also restarted the SQL Server Agent on node 1 of
the cluster using services manager.
Next, I set up a notification on a simple backup job to send an email
to the operator when the job completes.
However, the email is never sent out when the job completes. I have
checked the operator history and there is no history of an email ever
being sent. I also checked the current log and there are no error
messages whatsover regarding the mail not being sent. I also checked
the application log on node 1, and there is no error there either.
I have run the backup job several times now, send myself another test
email from the server (which works fine), but for some reason the email
just won't send on job completion.
Has anyone had this problem and how to resolve it? I though restarting
the Agent would solve the problem, but it has not.
ThanksI have run into the same problem. I use sp_send_dbmail and run this step at
the end of my job:
EXEC msdb.dbo.sp_send_dbmail
@.profile_name = 'Hilary',
@.recipients = 'myemail@.myemail.com,
@.query = 'exec master.dbo.xp_fixeddrives' ,
@.subject = 'Disk Space from MyDB'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<tootsuite@.gmail.com> wrote in message
news:1162832367.375831.237680@.h48g2000cwc.googlegroups.com...
> Hello,
> re: SQL Server 2005, SP1
> I set up Database Mail on a clustered server using the db mail wizard
> in Management Studio. I set up an operator using a mail group. The test
> email worked fine. I also restarted the SQL Server Agent on node 1 of
> the cluster using services manager.
> Next, I set up a notification on a simple backup job to send an email
> to the operator when the job completes.
> However, the email is never sent out when the job completes. I have
> checked the operator history and there is no history of an email ever
> being sent. I also checked the current log and there are no error
> messages whatsover regarding the mail not being sent. I also checked
> the application log on node 1, and there is no error there either.
> I have run the backup job several times now, send myself another test
> email from the server (which works fine), but for some reason the email
> just won't send on job completion.
> Has anyone had this problem and how to resolve it? I though restarting
> the Agent would solve the problem, but it has not.
> Thanks
>