Getting error "[311] Maildispatcher Thread (ID 1444) still running" when I try to restart

H
I am using SQLMail in my SQL Servers for the alert notifications. Today it has failed due to some reasons. I was trying to restart the SQLServerAgent , I got the error "[311] Maildispatcher Thread (ID 1444) still running"
It may be as the SQL Mail is conflicting with SQLServerAgent
Can you please tell me how to resolute this issue without restarting the MSSQLServer Services
Some forums say that, remove the mail profile from the SQLServerAgent Properties. This condition is true when the SQLServerAgent is running. But when it is stopped then there is no profile desplayed in the property box
Please help..
Thanks in advanc
DJ> I am using SQLMail in my SQL Servers for the alert notifications.
> Today it has failed due to some reasons. I was trying to restart
> the SQLServerAgent , I got the error "[311] Maildispatcher Thread
> (ID 1444) still running".
> It may be as the SQL Mail is conflicting with SQLServerAgent.
> Can you please tell me how to resolute this issue without
> restarting the MSSQLServer Services.
> Some forums say that, remove the mail profile from the
> SQLServerAgent Properties. This condition is true when the
> SQLServerAgent is running. But when it is stopped then there
> is no profile desplayed in the property box.
> Please help...
> Thanks in advance
> DJ
>
--
Hi DJ,
It looks like SQL Agent was abruptly stopped whilst SQL Mail was still
running. To get SQL Agent running, remove SQL mail profile by running the
following:
EXECUTE msdb.dbo.sp_set_sqlagent_properties @.email_profile = 'N'
Once you have SQL Agent started, add back the mail profile and then
troubleshoot the SQL Mail problem as you would normally do. This article
might help:
HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server
http://support.microsoft.com/?id=153159
Regards,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.