Not able to send alert email to a group mail account using database mail

Question

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

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

Johan Bijnens SSC Guru Points: 135582 More actions · Answer 1

You may need restart sqlagent to activate the first alert !

for the rest: It does not know a individual address from a group address

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

M&M SSC-Insane Points: 21700 More actions · Answer 2

Yes I did. The alerts are working fine only for individual ids

But I surprised it doesn't work for group email.

M&M

Johan Bijnens SSC Guru Points: 135582 More actions · Answer 3

is it your dbmail failing (error info ?)

or is it your mailserver holding back the mails because of some anti spam measures ?

Check with your mail admins.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Jerry Hung SSChampion Points: 12968 More actions · Answer 4

is it a Email Group name like "All Company"?

or an email list like "sqldba@company.com" that actually consists of multiple emails

There shouldn't be a difference between Individual@company.com vs Group@company.com as far as Database Mail is concerned

It simply relays the message to the SMTP server, and that's considered a success

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

M&M SSC-Insane Points: 21700 More actions · Answer 5

It is an email list like "sqldba@company.com" that actually consists of multiple emails.

Do you think the SMTP server might be the reason for this error.

It is just not able to identify this group email.

M&M

Jerry Hung SSChampion Points: 12968 More actions · Answer 6

If you can afford to send a test email to "sqldba@company.com" in Outlook or whatever email program, do that. That's the best way

If that works, SQL Database Mail should work (did Database Mail show success?)

If not, talk to the IT Administrator?

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

M&M SSC-Insane Points: 21700 More actions · Answer 7

You are right. I contacted the IT administrator, and he was able to give me the right SMTP server.

That worked.

Thanks for the help.

M&M