Wednesday, March 7, 2012

Mail Notifications Stop Working

We have some jobs that should e-mail the operator upon certain conditions.
For reasons I cannot seem to find, the e-mail notifications have stopped com
ing (net sends do work). I can send mail from the SQL Agent service account
from the desktop, but SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kno
w where to go. Have checked the accounts, stopped and started the agent, et
c. If this is a clue, the agent also won't run some scheduled jobs. One da
ily job actually last ran two days ago, yet I don't see any errors or messag
es. Using Win2K, SQL2K (SP
3a) on a 4-processor Dell box.Do you have any warnings or errors in your SQL Server Agent
Error log - right click on SQL Server Agent in Enterprise
Manager and select Display Error Log.
Also - are you by any chance running in fiber mode?
-Sue
On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
<DaveK@.discussions.microsoft.com> wrote:

>We have some jobs that should e-mail the operator upon certain conditions. For rea
sons I cannot seem to find, the e-mail notifications have stopped coming (net sends
do work). I can send mail from the SQL Agent service account from the desktop, but
SQL
won't even send me a test mail from within SQL (using Ent. Mgr). However, S
QL thinks the mail was sent OK, as it says "mail successfully sent". Howeve
r, the test mails never show up. Short of rebooting the server (a 24/7 prod
uction server), I don't kn
ow where to go. Have checked the accounts, stopped and started the agent, e
tc. If this is a clue, the agent also won't run some scheduled jobs. One d
aily job actually last ran two days ago, yet I don't see any errors or messa
ges. Using Win2K, SQL2K (S
P3a) on a 4-processor Dell box.|||Not using fibers. The only messages in the agent error log are the normal i
nformational ones that are found when restarting the agent, i.e., version, p
rocessors, memory, etc. It says the mail session was successfuly started.
"Sue Hoegemeier" wrote:

> Do you have any warnings or errors in your SQL Server Agent
> Error log - right click on SQL Server Agent in Enterprise
> Manager and select Display Error Log.
> Also - are you by any chance running in fiber mode?
> -Sue
> On Tue, 20 Jul 2004 13:33:03 -0700, "DaveK"
> <DaveK@.discussions.microsoft.com> wrote:
>
QL won't even send me a test mail from within SQL (using Ent. Mgr). However,
SQL thinks the mail was sent OK, as it says "mail successfully sent". How
ever, the test mails never show up. Short of rebooting the server (a 24/7 p
roduction server), I don't
know where to go. Have checked the accounts, stopped and started the agent,
etc. If this is a clue, the agent also won't run some scheduled jobs. One
daily job actually last ran two days ago, yet I don't see any errors or mes
sages. Using Win2K, SQL2K
(SP3a) on a 4-processor Dell box.[vbcol=seagreen]
>

No comments:

Post a Comment