SQL Mail

  • Hi,

    I have a T-SQL Job that does a T-SQL batch.

    I want to be able to e-mail the results of the T-SQL job to an Operator user with SMTP.

    Every time message is successfully sent, but I don't receive it.Sometimes I receive it only after restart my computer.What's happend?

    Thanks a lot,

    Jelena

  • Check the settings of the e-mail client on the server. Chances are it is not polling for a send/recieve to the SMTP server. Outlook, for example, polls SMTP servers on an interval to send any mail in the outbox and to recieve any mail from the server - its not a constant connection. When you start the Outlook client, it polls right away to send and recieve new mail. Chances are the computer loads Outlook at boot time so it polls then.

    You can change the polling interval under tools / options / mail services. The default is sixty minues.

    Edited by - Void on 03/29/2002 12:54:39 PM

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

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