Re: Failed to notify 'DBA' via email
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 12/09/04
- Next message: Mike Epprecht \(SQL MVP\): "Re: Installation Error: Error performing inpage operation"
- Previous message: David Hekimian: "Executing a Stored Procedure via Query Analysier is faster then a"
- In reply to: Moh Abb: "Failed to notify 'DBA' via email"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Dec 2004 17:00:12 -0500
Moh,
FWIW - SQL Server MAPI will only wait a certain amount of time to deliver a
message. If it cannot get out, then the mail will 'fail' even though
Exchange is up and running and healthy. It might be Exchange, networking,
domain issues, etc. that cause the problem.
If you Google on "sql mail Failed to notify" you will see a few comments on
this, without any real help that I could find.
(Unless xp_smtp_sendmail would work for you.)
RLF
"Moh Abb" <mabbas@aligntech.com> wrote in message
news:eiv3swh3EHA.3376@TK2MSFTNGP12.phx.gbl...
> We have some SQL jobs those run on a schedule basis. These jobs are setup
to
> notify us via email in case of job fails. However, Some time we get this
> error "Failed to notify 'DBA' via email." Initially I thought it may be
b/c
> of mail server was not available but our exchnage server admin has looked
at
> exchange logs and not found any thing at that time. I also looked at the
SQL
> server logs and did not find any issues. My question is: is there any
thing
> can go wrong in the SQL server that can cause this probelm?
>
> Help is appreciated.
>
> Thanks,
> Moh
>
>
- Next message: Mike Epprecht \(SQL MVP\): "Re: Installation Error: Error performing inpage operation"
- Previous message: David Hekimian: "Executing a Stored Procedure via Query Analysier is faster then a"
- In reply to: Moh Abb: "Failed to notify 'DBA' via email"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
