Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Notification Services

Nothing happens... how to debug NS?

I created my Notification instance, enabled, register, start sucsesfully.

Then I added Subscription and Subscriber

Finally I run the query to add Events to my event class.

The NSEventBeginBatch<EventClass> returns a valid BatchId

The NSEventWrite<EventClass> inserts 1 row

And NSEventFlushBatch<EventClass> also works...

But nothing happens... No email or File, no logs anywhere and no Events in the event viewer... How do I trace the notification progress?

Thx,

Uri

[548 byte] By [UriKluk] at [2008-2-13]
«« Textbox redraw problems on ActionPane
»» Handle error
# 1

Hi Uri -

Sounds like you've ensured that the events are being submitted correctly. You may want to double check to make sure the event data will indeed match a subscription you've created.

Are notification batched being created for the notification class? You can use the NSNotificationBatchList sproc to check.

Here's a link to some more diagnostic reports provided by SQLNS.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/4204961e-5d99-4ec9-88a1-e410e4b2ab3f.htm

HTH...

JoeWebb at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Notification Services...
SQL Server
SQL Server Notification Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified