all groups > sql server notification services > march 2006 >
You're in the

sql server notification services

group:

"DeliveryFailed" status


"DeliveryFailed" status Mana
3/29/2006 4:32:29 AM
sql server notification services:
Hi,

I am using SQL Server 2005 Notification Services.

I have written an application which uses a standard delivery protocol
(FILE) and a few custom delivery protocols.

I want to display the log of notifications sent. This information can
be found in NSMyEventClassNotificationDistribution view, where
MyEventClass is the name of Event Class.

When I send notification using my custom-written delivery protocol, the
DeliveryStatusDescription column of view mentioned above shows entry
as "Delivery Failed". But I recive the notification without any
problem. If I send notifications to FILE, the entry says "Delivery
Succeeded" and I also get the notification.

Why is it showing "Delivery Failed" in case of custom protocols even
when I receive notifications?

Mana
Re: "DeliveryFailed" status Joe Webb
4/4/2006 12:00:00 AM
Hi Mana -

Delivery channels work asynchronously for performance reasons so SQLNS
has no way of immediately knowing whether delivery succeeded or not.
In your custom delivery protocol, are you invoking the notification
status callback delegate?

HTH...

--
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On Tue, 4 Apr 2006 01:00:02 -0700, Suparichithudu
[quoted text, click to view]
RE: "DeliveryFailed" status Suparichithudu
4/4/2006 1:00:02 AM
Hi
I appears to me that, 'Failed' is the default and you are not changing the
value through your custom protocol. Update value to 'success', everytime you
send notifiaction. NS is only a facilitator.
--
Thanks in Advance
Regards
Suparichitudu



[quoted text, click to view]
Re: "DeliveryFailed" status Mana
4/10/2006 2:31:18 AM
Yes, I m calling the notificationStatusCallback delegate.
AddThis Social Bookmark Button