MSDB Database Mail Shut down

Vaishnavi Gopalakrishnan 1 Reputation point
2021-04-08T20:27:41.387+00:00

The database mail is shutting down in 10 seconds automatically. Tried all the work around. Nothing worked. Kindly assist.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,708 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,091 Reputation points Microsoft Vendor
    2021-04-09T02:30:07.633+00:00

    Hi @Vaishnavi Gopalakrishnan ,

    What is your SQL server version? Using select @@version to check this. Please read your Database Mail Log to find some useful information, and share us the information for analysis. Management->Database Mail->View Database Mail Log

    Did you check the values of Database Mail Executable Minimum Lifetime as below screenshot? SSMS object> Management > Database Mail Configuration Wizard

    85969-screenshot-2021-04-09-101008.jpg

    Check if this thread could help you.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

  2. Tom Phillips 17,716 Reputation points
    2021-04-09T17:14:50.9+00:00
  3. Erland Sommarskog 101K Reputation points MVP
    2021-04-09T21:09:51.567+00:00

    The message sounds like it relates to one of the internal Service Broker queues.

    What does this query return 

    SELECT name, is_activation_enabled, is_receive_enabled, is_enqueue_enabled 
FROM msdb.sys.service_queues WHERE name LIKE '%MailQueue'

    Now, if any of these queues are stopped, I'm not sure what do with that, but we'll see.

  4. Vaishnavi Gopalakrishnan 1 Reputation point
    2021-04-12T01:43:16.697+00:00

    We got it resolved through a person from Microsoft. He helped our IT guy to fix it.

  5. Vaishnavi Gopalakrishnan 1 Reputation point
    2021-04-12T01:44:38.293+00:00

    Thank you all for your recommendation. I will post the solution if I get to know it. We had a McAfee installation. Our team doubted that it caused the problem.