Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
how to limit number of mails per hour in sql database mail

Answered how to limit number of mails per hour in sql database mail

  • Friday, July 20, 2012 6:48 AM
     
     
    Sign In to Vote
    0

    Hi,

    I want to send bulk emails (more than 500) mails through the SQL database mail to my customers. But I am allowed to send only 100 mails per hour through my SMTP server. How can I limit the number of mails per hour sent through the database mail?

    Thanks in advance.

    • Moved by Iric WenModerator Tuesday, July 24, 2012 2:28 AM (From:SQL Service Broker)
    •  
     

All Replies

  • Friday, July 20, 2012 7:27 PM
     
     Answered
    Sign In to Vote
    0

    Option of setting no. of mails in one hours is can be set at SMTP levle only, no option avilbale in SQL Database mail (directly).

    But indirectly you can one thing : Create one customised mail queue > Route all mails through this queue > Now Schdule a job to send 100 mail in each run & schedule it for each 1 hour.

    But again the upper limit will be as per the setting on SMTP server.

    Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!


     
  • Tuesday, July 24, 2012 3:00 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Hi jeyan,

    As RohitGarag mentioned, in SQL Server side, we cannot configure the SMTP server to allow sending more mails.
    Suggest you to contact your SMTP server admin to cancel or reduce this limit.

    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.