index > SQL Server Notification Services > Nothing happens... how to debug NS?

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

Uri Kluk

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...




Joe Webb, SQL Server MVP | http://www.sqlns.com
Joe Webb
reply 2

You can use google to search for other answers

 

More Articles

• How to send Notifications to WinForm?
• BSM - Alerts
• Null Instance
• Can I have multiple tables to gather event data
• Description: String cannot have zero length. Event ID: 6003
• How can i check if Notification Services engine components is ins...
• How to receive mails, when a record is entered into my error log ...
• SQL Server Alert Notification Systems
• regarding select into statement
• HTML formatting tags in XSLT getting lost
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• Best Project Template & "The Vi
• Null Instance
• Error in Registering Instance using Mana
• trigger not running on insert
• NS Data
• new to notifications services and want e
• The notification could not be formatted.
• Queing email
• Missing Text in Notifications via SMTP
• NS 2.0 and SQL Server 2005?
• Query notification from Win32
• Database Mail SMTP authentication
• Subscription matching and linked servers
• Adding subscibers periodically.
• OT: SQLNS community site?

Hot Articles

• How to append data from a T-sql qurey to
• SqlCacheDependency - Notification Servic
• New SQL-NS 2005 Book
• Visual Studio 2005 and NS 2.0
• Notification Services - Chronicle does n
• Details of SubscriptionClass Class
• Nofications assemblies not found with .n
• .NET Framework 2.0 question - continued...
• How can I list out all the server names
• Not able to receive the mails
• Fatal exception while firing a rule
• Unable to start new instance in Notifica
• Transactions in NS API (Found a way to d
• The e-mail address or SMTP server value
• NS 2.0 SP1 Install Problem

Recommend Articles

• NS 2.0 SP1 Install Problem
• Getting SPN error after installing Beta2
• Fatal exception while firing a rule
• new to notifications services and want e
• How to get details for user-defined cond
• How to send notification to .aspx page...
• Problem with ConditionAction SqlLogin
• Mailing dba when Sql Server Agent Fails
• EMail Notifications
• SQL-NS 2005 resources and 3rd parties
• SQL Server Alert Notification Systems
• Missing Text in Notifications via SMTP
• Checking for free disk space and getting
• Companies or projects based on NS?
• Migration Problem with NS SQL 2000 to NS