1

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 - [email protected]), nothing is sent out.

Any suggestions?

trobbie

Improve this question
3
  • Do you see any error messages when you run SELECT * FROM msdb.dbo.sysmail_event_log
    – RK Kuppala
    Commented Feb 24, 2012 at 12:01
  • hi, there is no error message - just "Database mail has started"
    – Trobbie
    Commented Feb 24, 2012 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
    Commented Feb 24, 2012 at 15:02

1 Answer 1

Reset to default
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 ;

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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