[Top] [All Lists]

Re: Event Info

Subject: Re: Event Info
From: "andyjax"
Date: Mon, 27 Jun 2005 09:20:04 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
The EventBatches table has something like the following:
EventBatchID     ProviderID    EventCount
6               1                  0    

My sample data should be 10 records. The number of things to compare on is 
25 things to match on. Not sure if the event data is too wide.

In response to your other post looking for errors in the Application Log, 
this is what I found:
Description: Some notifications cannot be delivered because they reference 
non-existent subscribers, unknown subscriber device names, or unsupported 
protocols for the notification class. Use the NSDiagnosticFailedNotifications 
stored procedure for details about undeliverable notifications. 

I tried to run the procedure, but nothing comes back as a logged problem. I 
am using SQL 2005 June CTP Dev Edition on Windows XP.

"Joe Webb" wrote:

> Hi Andyjax - 
> If things are working correctly, you should see event data in the
> NS<EventClassName>Events table and a record of the batch in the
> NS<EventClassName>EventBatches table in the application database. 
> Are there errors in the application event log? 
> -- 
> Joe Webb
> SQL Server MVP
> ~~~
> Get up to speed quickly with SQLNS
> I support PASS, the Professional Association for SQL Server.
> (
> On Mon, 27 Jun 2005 08:30:01 -0700, "andyjax"
> <[email protected]> wrote:
> >I am working through Shyam's book trying to look to make sure the 
> >application 
> >is working as needed. The processing of my data using a filewatcher 
> >processes 
> >the file done, but I don't see a batch in the NS<Service Name>Events table.
> >
> >Am I missing something, or should I not worry about it? The MusicStore 
> >example in the book is working just fine. I am just trying to build a 
> >prototype and taking the slow process of adding a little bit more each time 
> >as Shyam suggests.
> >
> >Any help would be appreciated. 

<Prev in Thread] Current Thread [Next in Thread>