Home Forums SQL Server 2008 SQL Server 2008 Administration Database Mail Queue stuck in INACTIVE State - can't get Database Mail to work on Server RE: Database Mail Queue stuck in INACTIVE State - can't get Database Mail to work on Server

  • March 23, 2012 at 9:18 am

    #1463476

    Lowell (3/23/2012)

    I believe you are incorrect; the default state would be INACTIVE unless you query the queue at teh exact moment you are actually sending an email.

    all four of my servers i just checked all show INACTIVE, nad one ran an email campaign this morning at 7am wiithout errors.

    Thanks for correcting me.

    I sent mail and checked it and the status and it was still INACTIVE.

    The problem is that all of the items are in the queue and none have been sent.

    I tested SMTP Mail with Telnet and it worked.

    Any suggestions?

    Thanks again.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/