Re: Pause/Continue distribution, content formatting or deliverin
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
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.
Get your notification services implementation going in minutes not