Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Database Mail

Author  Topic 

olestoepoke
Starting Member

1 Post

Posted - 2012-03-23 : 10:55:39
Hi All,

Having some issues with Database Mail. first off I've configured the Database Mail module and have enabled the XPs bits which need to be enabled for it to work.

I'm able to send a test email through no problems at all, however when my DB does it's backup, it has a notification to email the specified address upon completion... which it doesn't.

I cannot for the life of me figure out why. Any ideas?

rickymartin
Starting Member

2 Posts

Posted - 2012-04-01 : 00:32:50
Hi,

We need to create operator under sql server agent. Add that operator under alert system tab of sql server properties and enable the fail safe operator and restart the sql server agent after the change.

Let me know in case of issues.
Go to Top of Page
   

- Advertisement -