[Top] [All Lists]

Re: Is there any indicator that show that event generation is fini

Subject: Re: Is there any indicator that show that event generation is fini
From: R.D
Date: Wed, 25 Jan 2006 00:05:02 -0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Thank you for your reply. I want to fetch the results of counters in my 
stored procedure. I mean I want know when exactly the notification generation 
is finished so that I can run my own query as part of another procedure used 
by sql provider.
is it possible?
I think that must be stored in some table.

--Knowledge gets doubled when shared

"Joe Webb" wrote:

> There are component level objects that provide information about the
> Distributor, Delivery Channels, Event Providers, and Generator. 
> Here are some links to SQL Server 2005 BOL.
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ab553c22-329d-480c-ad77-b898cd761adb.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ac05465a-1b29-4d1f-acb3-1826d9fa5299.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/80159049-eb12-4d05-ab72-caac856bffde.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/8c212998-caf7-4f3a-8ff2-9a94719b3dae.htm
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/cf9c80b0-c8b5-47d2-8d90-692a26080739.htm
> Are you looking for something beyond these Performance objects? 
> -- 
> Joe Webb
> SQL Server MVP
> ~~~
> Get up to speed quickly with SQLNS
> I support PASS, the Professional Association for SQL Server.
> (
> On Tue, 24 Jan 2006 06:01:02 -0800, R.D <[email protected]>
> wrote:
> >Hi all
> >Can anyone tell me how to know that the events generation is finished and 
> >notification generation has started. or the ns is doing distribution of 
> >mails.
> >
> >I would like to know what exactly ns is doing(at what stage it is) 
> >programmatically is it possible.
> >
> >Thanks in advance

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