SQL Server Agent - E-Mails

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Fresh Air Rider
    #1

    SQL Server Agent - E-Mails

    Hi Folks

    Could anyone please tell me if there is a maximum number of E-Mails
    that SQL Server Agent can send at any one time ?

    I'm thinking of using it to send out matches from the database that
    registered users have previously specified.

    Thanks
    David
    Tags: None
    • John Bell
      #2
      Re: SQL Server Agent - E-Mails

      Hi

      If you try and send a significant number of emails consecutively it may
      overload the exchange server, you would probably better off batching them up
      and sending them periodically.

      John

      "Fresh Air Rider" <Fresh_Air_Ride r@Hotmail.com> wrote in message
      news:556722cb.0 504151253.5bdc3 f1@posting.goog le.com...[color=blue]
      > Hi Folks
      >
      > Could anyone please tell me if there is a maximum number of E-Mails
      > that SQL Server Agent can send at any one time ?
      >
      > I'm thinking of using it to send out matches from the database that
      > registered users have previously specified.
      >
      > Thanks
      > David[/color]


        Comment

        • Mike Epprecht \(SQL MVP\)
          #3
          Re: SQL Server Agent - E-Mails

          Hi

          You real limitation is how fast your servers are and how quickly Outlook
          (MAPI) can do it's work.

          If you need to send a huge amount of mail, it is better to do it in an
          application that uses SMTP as it is more efficient.

          Regards
          --------------------------------
          Mike Epprecht, Microsoft SQL Server MVP
          Zurich, Switzerland

          IM: mike@epprecht.n et

          MVP Program: http://www.microsoft.com/mvp

          Blog: http://www.msmvps.com/epprecht/

          "John Bell" <jbellnewsposts @hotmail.com> wrote in message
          news:4260c12e$0 $2588$da0feed9@ news.zen.co.uk. ..[color=blue]
          > Hi
          >
          > If you try and send a significant number of emails consecutively it may
          > overload the exchange server, you would probably better off batching them
          > up and sending them periodically.
          >
          > John
          >
          > "Fresh Air Rider" <Fresh_Air_Ride r@Hotmail.com> wrote in message
          > news:556722cb.0 504151253.5bdc3 f1@posting.goog le.com...[color=green]
          >> Hi Folks
          >>
          >> Could anyone please tell me if there is a maximum number of E-Mails
          >> that SQL Server Agent can send at any one time ?
          >>
          >> I'm thinking of using it to send out matches from the database that
          >> registered users have previously specified.
          >>
          >> Thanks
          >> David[/color]
          >
          >[/color]


            Comment

            Previous template Next
            Working...