Actually, what Colin suggests will only affect the retry schedule of future
notifications. Those that already exist in the database will not be affected
by the retry schedule change.
NS does not support forcing a retry of existing notifications outside of the
defined schedule. The only way to achieve this is to manually edit the
distributor work item records in the database. However, I need to stress
that this is definitely NOT supported and doing so might lead to unexpected
problems. Given this, if you still want to try, you will need to update the
NextRetryTime column of the appropriate rows in the NSDistributorWorkItems
table. Remember that times need to be specified in UTC.
Thanks
-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] "Colin Meek [MSFT]" <CMeek@online.microsoft.com> wrote in message
news:ugrAEjz8EHA.824@TK2MSFTNGP11.phx.gbl...
> Hi Joe,
>
> You can change the retry schedule by configuring
> NotificationClasses/.../ProtocolExecutionSettings/RetrySchedule element in
> the application definition file
>
(
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/ht
> m/nsp_applicationdefinitionfile_1juc.asp). Details on updating an NS
> instance can be found at:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlntsv/htm/ns_adminapps_9n79.asp.
>
> There is no way of forcing work items to be retried immediately, but by
> changing these settings, you can hopefully get what you need!
>
> -Colin
>
> --
> 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. >
> Please do not send e-mail directly to this alias. This alias is for
> newsgroup purposes only.
> --
>
> news:1104757667.202326.53970@f14g2000cwb.googlegroups.com...
> > My next retry schedule is after 5 hours, how can i force all of the
> > distributor work item run now? should not wait for next retry schedule.
> >
>
>
