Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have set up a profile and operator within SQL Server 2008. I also have an operator that is a group in MS Outlook.

When I use the single user address as the notification address when a job completes, the email is sent out (so profiles and mail is working). When i use the group address (its exactly the same format as the single user one - abc@abc.co.uk), nothing is sent out.

Any suggestions?

trobbie

share|improve this question
    
Do you see any error messages when you run SELECT * FROM msdb.dbo.sysmail_event_log –  yogirk Feb 24 '12 at 12:01
    
hi, there is no error message - just "Database mail has started" –  Trobbie Feb 24 '12 at 13:04
    
Did you confirm that if you send an e-mail manually to that account it gets received? Make sure to send from the same machine and through the same SMTP server. –  Aaron Bertrand Feb 24 '12 at 15:02
add comment

1 Answer 1

Have you created a contact group in Outlook or a Distribution group in Exchange? (I'm assuming you are using Exchange?)

The Outlook group is just a container that lets you send emails to many people from your personal machine. The SQL Server is trying to send to a group that exists only on your Outlook and not on the Exchange server which is why single email recipients work but not the group.

I would suggest setting up, or asking your email admin to setup a new SQL support distribution group on your mail server.

or

You can send to multiple single email addresses by separating the address of the recipient with a ;

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.