Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Can Event Batch ID be related to resulting Notification Ba..

 
   Database Forums (Home) -> Notification Services RSS
Next:  Accessing NS Instance on a Database Server from a..  
Author Message
BigDave

External


Since: Jun 27, 2007
Posts: 1



(Msg. 1) Posted: Wed Jun 27, 2007 10:49 am
Post subject: Can Event Batch ID be related to resulting Notification Batch ID(s)?
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

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

 >> Stay informed about: Can Event Batch ID be related to resulting Notification Ba.. 
Back to top
Login to vote
Todd C

External


Since: Nov 16, 2005
Posts: 110



(Msg. 2) Posted: Wed Jun 27, 2007 1:18 pm
Post subject: RE: Can Event Batch ID be related to resulting Notification Batch ID(s [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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]


"BigDave" wrote:

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

 >> Stay informed about: Can Event Batch ID be related to resulting Notification Ba.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
database 'DBNAME' is not enabled for SQL cache notification - I'm getting this message on SqlCacheDependencyAdmin.EnableTableForNotifications and aspnet_regsql.exe -C connstr -lt Yet, the following execution has finished successfully: ALTER DATABASE dbname SET ENABLE_BROKER

Failing NSEvent Begin Batch procs - Hello All: I have a somple NS app with an Event Class. I am submitting events as follows: The source Db has a trigger that gets fired ON INSERT The trigger call a Stored Procedure in the same Database. The SP then calls the 3 procedures in NS to submit...

time event? - Hi, I have some data in my database which stores when a contract expires. I'd like to send a notification 90, 60 and 30 days before the contract will expire. I'm having trouble coming up with a good event to trigger notifications. Do I setup the event...

Multiple notification about the same event - Hello, after some struggle, I created my first trivial notification applicaiton. One problem I don't quite understand. Let's say, I want to generate notification whenever in the table1 there's new record with col1='x'. Will NS ensure that each such..

Event Chronicles and Rules - Hi all, I am attempting to create a simple event chronicle that stores the last run time, per the example in Shyam's most recent book regarding SQL 2005. The below snippet is an example of what I have for this chronicle and rule specifically. ..
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]