microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Event Info

Subject: Re: Event Info
From: Joe Webb
Date: Mon, 27 Jun 2005 16:13:28 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Andyjax - 

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

Events are submitted in batches as we discussed before. Then when the
generator fires, the matching rules are executed. So they don't have
any impact on your event submission problem.

HTH...

-- 
Joe Webb
SQL Server MVP


~~~
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 Mon, 27 Jun 2005 09:20:04 -0700, "andyjax"
<[email protected]> wrote:

>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 
>wide, 
>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
>> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 
>> 
>> I support PASS, the Professional Association for SQL Server.
>> (www.sqlpass.org)
>> 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>