• Mike Saedi - Wednesday, January 17, 2018 5:34 PM

    Hi Sue,
    First query returns a value of 1, for is_broker_enabled.
    Second query returns a value of STARTED for status.
    Test e-mail returns additional records to the sysmail_allitems view but all records show up as "unsent" under the sent_status column as before.

    Do you have any other thoughts?

    Thanks again,
    Mike

    Mike -

    When you were able to send an email initially, did it really send or was that in the unsent as well? Did you just get a message of it being queued for processing?
    If that's the case and you have never actually received any of the test emails then mail isn't setup right. Make sure the account for that profile being used is set correctly, whoever manages the mail/smtp is allowing relays for that server, need to use the correct ports and have the traffic allowed on the firewall for those ports, the required authentication, etc.
    I'd try another query of dbo.sysmail_event_log in msdb and make sure you are running it against the correct server. Not getting errors and nothing being logged doesn't make sense.
    Otherwise I'm running out of ideas. Check the queues is all I can think of. Check if the mail queue was activated recently:
    EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'

    And then check the queues in msdb to see if anything is backed up:
    SELECT * FROM dbo.ExternalMailQueue
    SELECT * from sys.transmission_queue

    Sue