Help Database Mail Doesn't Work

[txdave35]

I have spent most of today trying to get database mail in SQL 2005 to send me an email when our maintenance plan is executed.

I went through the process of creating a profile in Database Mail. Set up configuration under SQL Server Agent, and in notifications as well. In Database mail, I click the test mail, and it will email me the test message. But nothing when the maintenance plans excecutes.


The log file is telling me:

"an attempt was made to send an email when no email session has been established". I checked the mail status and it shows "RECEIVES_OCCURRING".

I am at a loss here. If the test email went through, that tells me that it is not a profile configuration issue. Any thoughts? Thanks.

 

[txdave35]

Whoa, looks like I solved my own problem. Restarted the SQL Server Agent and got the email! lol

 

[JayKusch]

Yup ... SQL Server Agent restart is usually needed.

Thanks

J. Kusch

 

[txdave35]

Do you know if there is any way for Database mail to email more than one person on a maintenance plan? The notification screen in the job properties only allows me to pick one user.

Thanks!

 

[JayKusch]

You can set up a group via AD and use that.

I prefer not to use maintenance plans. I create my own SQL jobs and execute the needed task (backups, optimizations, integrity checks, ect.)

I would rather have the control and error/execution logging I can implement over the default, out-of-the-box settings a Maint plan offers.

As for this thread, you could then use sp_Send_DBMail and set the @recipients equal to any group and/or individuals you choose (just separate them by a semicolon).


Thanks

J. Kusch