Sunday, February 19, 2012

Database Mail 101

Question 1: From what I understand, Database Mail can only be used to Send, not Receive, email. Is this correct?

Question 2: I can hear our developers saying "way too complicated. When an error conditon is sensed by our app we can simply have the app send an email to our email server. Done." With that in mind what does Database Mail have to offer our developers that they can't easily do in their app?

TIA,

Barkingdog

Hello,

1: Yes. DBMail can only be used to send.

2: For a start, Dbmail can be used to issue e-mail alerts in response to database-engine related events (job completion, errors etc) as well as including query results in the message. I believe you'd have a hard (time consuming) time incorporating this functionality into an application to the same degree of reliability that DBmail provides out-of-the-box.

Cheers,

Rob

No comments:

Post a Comment