Groups | Blog | Home
all groups > sql server notification services > june 2007 >

sql server notification services : Can Event Batch ID be related to resulting Notification Batch ID(s)?


BigDave
6/27/2007 10:49:52 AM
Hi all,

We'd like to write a little web view showing events coming in, and the
resulting notifications - in terms of their real-time status (via
NSDistributorWorkItems table).

But surprisingly, we're finding it difficult to tie an Event Batch ID
to its resulting Notification Batch ID(s) within the database.

Any tips?

Thanks,
Dave
Todd C
6/27/2007 1:18:00 PM
BigDave:
I'm not an expert by any means in NS, but here is my take on it:

I think the data you want will ONLY be available during the time the current
Quantum is processing it. After that, it will no longer be available.

So, what about setting up a Chron table on the Event class to capture the
EventBatchID along with the Event info? That would keep a static record of
which BatchID each Event was associated with.

As for keeping a static record of the Batch itself, not sure.

Any other suggestions out there?

--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


[quoted text, click to view]
AddThis Social Bookmark Button