Post reply

Sending automated email from SQL server

  • February 23, 2011 at 6:27 am

    #144737

    Hello,

    We have a requirement in which an automated e-mail need to be sent to some email id. In case if the email address is incorrect it should fail immediately. In case mailbox of receipient is full or mail server is unavailable then our job should automatically retry to send email after specific duration.

    Right now we are using DatabaseEmail (in msdb database) for sending email. But in case of incorrect email address or server unavailable or if mailbox is full; synchronous repsonse is not received to proceed for automatic retry.

    Has anyone worked on this earlier? I also do not want to use msdb as it is a system database and may get loaded. is any other way of achieving this?

    Any help is this regard is appreciable.

    Thanks

    Vishal

  • February 23, 2011 at 6:43 am

    #1290348

    you want some code/mail option to make mails from SQL as smart as a SMTP server

    cant help you with that.

    But, what you can do is to drop the mail to a smtp server (iis smtp) and let that smtp server mail it for you. that one has abit more configuration possibilities concerning retrys time outs ect

  • February 23, 2011 at 6:47 am

    #1290353

    This is a good question but just to add database mail is an SMTP-based asynchronous mailing solution.

    I doubt if there is a way by which we could solve your query using database mail atleast.

    M&M

Viewing 3 posts - 1 through 2 (of 2 total)

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