In SQL Server database mail is not working
0
votes
0
answers
211
views
**Database mail is not working:**
Below Error while sending a test mail
Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. (Microsoft SQL Server, Error: 14641)
Checked all the settings of the service broker and Database Mail XPs all are enabled only. I ran the DBCC CHECKDB command on msdb also no error or inconsistency was found.
while starting the database mail using this query sysmail_start_sp
(dbo.sysmail_help_status_sp;) using this query we checked the status it is in the started state within 20 seconds automatically it returned to the stopped state.
Please help me out and give your suggestions.
Asked by Ajith Kumar M
(1 rep)
May 8, 2024, 04:27 AM
Last activity: May 8, 2024, 04:30 AM
Last activity: May 8, 2024, 04:30 AM