Email notification does not send 2

[sqlcasey]

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

 

[sqlcasey]

Thanks catadmin, I forgot about this step. I must have set this up on my other servers, but did not remember this step and forgot to document.

Mail is working now.

 

[Catadmin]

NP. Glad I could help.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"