how can a custom delivery protocol assembly know when it gets the last workitem in this pass of the distributor? -- sql server notification services

sql server notification services : how can a custom delivery protocol assembly know when it gets the last workitem in this pass of the distributor?

kate
8/25/2005 2:58:22 AM

in a custom delivery protocol we have just done we need to clean up
some transient files when all the work items in this cycle of the
distributor have been processed.

any ideas how we can detect this?

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......

Shyam Pather [MSFT]
8/26/2005 10:47:11 AM

Kate,
Can you define more clearly what you mean by "cycle of the distributor"?
-shyam

--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

kate
8/26/2005 11:59:26 AM

each time the distributor component wakes up and processes all the
pending workitems we term that a 'cycle'

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......

Joe Webb
9/2/2005 1:48:45 PM

In your scenario, does it have to be workitem specific? I don't have
Shyam's book in front of me at the moment, but I believe that when the
distributor wakes up, it keeps processing as long as there are things
to be done. So the "cycle" may include multiple workitems.

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

[quoted text, click to view]

kate
9/4/2005 4:02:04 PM

hi joe,

this is my second attempt at this as the stupid forum keeps clearing
out the post text. sigh.

does not have to be workitem specific , any signal or flag that would
indicate that the distributor cycle has ended would do. i would expect
any one cycle to have many workitems and this is not a problem. we just
need to refresh/cleanup some resources that were generated in our CF
and used during the calls to the CDP.

Kate MBCS

Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

home · blog · groups

Questions? Comments? Contact the dn