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

Re: Pause/Continue distribution, content formatting or deliverin

Subject: Re: Pause/Continue distribution, content formatting or deliverin
From: "kate"
Date: 12 Jul 2005 03:52:42 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
others may have more detail on this. but looking at the procs, the
createdistributorworkitem only occurs for generated work items in the
<instance>batches1 table with a notificationbatchesstatuscode of 3. you
could override this to zero which would effectively put the batch on
hold until you set it back to 3.

The dangers of this are , you have to have a window of time to change
the status codes before the distributor runs. this is difficult to
guaruntee.

If NS changes the way it works this will fail.

personally i think intervening at table level is too dodgy.

what would be better would be a look at a way of getting either a
custom content formatter or delivery protocol to implement this. to
stop the batch would be relatively straightforward. the problem would
be re-instating it as it could get expired or vacuumed before you
decide to let it thru.

Kate MBCS

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


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