Database Mail e-mail notifications not being sent on completion of backup jobs

Question

Database Mail e-mail notifications not being sent on completion of backup jobs

kaplan71

Hall of Fame

Points: 3634
More actions
January 6, 2013 at 5:32 pm

#393877

Hello --
I configured our backup jobs to send notifications to the administrators on their respective completion. However, the notifications have not been sent out on job completion. The jobs in question are part of a maintenance plan. When the email notifications were set up, the jobs themselves within the plan were modified rather than the maintenance plan itself. The server in question is running Windows Server 2008 R2 64-bit along with SQL Server 2008 Standard Edition.
The Database Mail utility was originally not enabled on the server, and became enabled during the procedure to set up notifications. An existing domain e-mail account was used as the intended recipient. An operator was set up for the mail notifications, and a test e-mail was sent to confirm the server was able to send out notifications. When the setup was completed, the SQL Agent was restarted.
A check of the job history indicated the backup jobs completed successfully. A check of the Database Mail history did not show any entries for the jobs that had been successful. What step(s) did I miss in this process in order to get the notifications to work?
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 1

I would start off with sending a test e-mail through Database Mail. That should test that your Database Mail profile and functionality is working as expected. Then double-check that your operators are correct and that e-mail addresses have not changed. After that I would look at the job steps again to ensure that with the maintenance plan step is complete it goes to the e-mail notification step as expected. Then you can test the Agent job starting at the e-mail notification step to ensure just that works. Then test the job from the first step to ensure that works as expected.

Joie Andrew
"Since 1982"

P Jones SSChampion Points: 12352 More actions · Answer 2

Mine stopped working and I found that the exchange server had been changed without my knowing!

I had to rapidly edit a bunch of servers' database mail settings.

In the SQL Agent itself there are settings - in Management Studio, right click the SQL Server Agent for the server and select properties and ensure Enable mail Profile is selected and Database mail also.

Then in each Agent job you need to set it the notification properties to notify operator on completion

kaplan71 Hall of Fame Points: 3634 More actions · Answer 3

Hello --

I checked through the settings, and it appears the problem was the spelling of the email address was incorrect. I made the change, and will restart the SQL Agent later tonight. I will keep everyone apprised of the results of the change.

Thanks.

kaplan71 Hall of Fame Points: 3634 More actions · Answer 4

Hello --

The problem continues to occur even though the email address was corrected, and the SQL Agent was restarted on the server. I checked the history of the most recent job, and the error message that I am seeing is the following:

The job succeeded. The Job was invoked by Schedule 17 (Backup <job name>.Backup Differential). The last step to run was step 1 (Backup Differential). NOTE: Failed to notify 'RODB Admins' via email.

What else can I do to correct this problem?

Thanks.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 5

Did anything get logged in the Database Mail log this time?

What happens if you run the job again, but start from the e-mail step?

Joie Andrew
"Since 1982"

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 6

Under the SQL Server Agent Properties >> Alert System, have you enabled a default mail profile and selected the proper fail-safe operator?

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

kaplan71 Hall of Fame Points: 3634 More actions · Answer 7

Hello --

Thanks for everyone's help. The issue was neither the Enable Mail Profile or Fail-Safe Operator options were enabled for the agent. Once those were set, and the agent restarted, the e-mails went through.

Thanks again.