Test scheduled events

External Since: Jan 31, 2005 Posts: 5

Hi Shyam,

I've had your book, and it worth every penny. Thanks.

Although I liked Joe's way better. Because the next day the same
subscription works again.

Weird thing is that, the "Notification Services" is hard to getting used to,
but once one gets the logic behind it, one doesn't anything else for
notification needs.

"Shyam Pather [MSFT]" <spather DeleteThis @online.microsoft.com> wrote in message
news:eM9%2329wCFHA.392@TK2MSFTNGP14.phx.gbl...
> Typically, I create a test program that simply creates a new scheduled
> subscription for two-minutes from "now". Whenever I want to test
> something,
> I run this program to enter a new subscription, then run the app to see
> what
> happens. You can of course adjust the two-minutes to something longer or
> shorter if desired.
>
> Chapter 6 of my book
> (http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/) has a section
> on
> testing scheduled subscriptions this way.
> -shyam
>
> --
> Learn more about SQL-NS:
<font color=purple> > <a style='text-decoration: underline;' href="http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/</font" target="_blank">http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/</font</a>>
> ---------------------------------------------
> 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
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/info/cpyright.htm.</font" target="_blank">http://www.microsoft.com/info/cpyright.htm.</font</a>>
> ---------------------------------------------
> "Joe Webb" <joew DeleteThis @webbtechsolutions.com> wrote in message
> news:O8cuk8VCFHA.3940@TK2MSFTNGP11.phx.gbl...
  >> Mert -
  >>
  >> If you're talking about testing scheduled subscriptions, then you can
  >> create multiple subscription throughout the day. For example the
  >> following c# code snippet would create a scheduled subscription for
  >> every minute of today.
  >>
  >> for (int hr = 1; hr < 24; hr++)
  >> {
  >> for (int mn = 1; mn < 60; mn++)
  >> {
  >> nsSubscription.ScheduleStart = "TZID=360:20050202T" +
  >> hr.ToString("00") + mn.ToString("00") + "00";
  >> nsSubscription.Add();
  >> }
  >> }
  >>
  >> Notice that this does not actually set the recurrence for a single
  >> subscription to a sub-day frequency; it creates lots of individual
  >> subscriptions. But should help you to test to make sure your
  >> subscriptions are working correctly.
  >>
  >>
  >> HTH...
  >> Joe Webb
  >> SQL Server MVP
  >>
  >> ~~~
  >> Get up to speed quickly with SQLNS
<font color=green>  >> <a style='text-decoration: underline;' href="http://www.amazon.com/exec/obidos/tg/detail/-/0972688811</font" target="_blank">http://www.amazon.com/exec/obidos/tg/detail/-/0972688811</font</a>>
  >>
  >>
  >>
  >> Mert Sakarya wrote:
   >> > Is there an easy way to test scheduled events or I have to wait at
   >> > least
> one
   >> > day for them to fire?
   >> >
   >> > Modifyin time doesn't help much. I think it messes the Quantum time.
   >> >
   >> > I got this eventlog error when I did that...
   >> > Message: 4016: The quantum end time is later than the current real
   >> > clock
   >> > time. Notification Services cannot process events that occur in the
> future.
   >> >
   >> > Procedure: NSScheduleQuantum1
   >> >
   >> > Line Number: 151
   >> >
   >> >
   >> >
>
>

External Since: Apr 28, 2004 Posts: 118

> I've had your book, and it worth every penny. Thanks.
JW>> Yep....agreed, Shyam book is well worth the price.
>
> Although I liked Joe's way better. Because the next day the same
> subscription works again.
JW>> Just make sure you set the ScheduleRecurrence property if you want
to have it repeat the next day. The code snippet that I posted didn't do
that.
>
> Weird thing is that, the "Notification Services" is hard to getting
used to,
> but once one gets the logic behind it, one doesn't anything else for
> notification needs.
JW>> Agreed. It takes a bit of getting used to, but once it clicks for
you, it's pretty straight forward. It's a cool product.

HTH...
Joe Webb
SQL Server MVP

~~~
Get up to speed quickly with SQLNS
<a style='text-decoration: underline;' href="http://www.amazon.com/exec/obidos/tg/detail/-/0972688811" target="_blank">http://www.amazon.com/exec/obidos/tg/detail/-/0972688811</a>

Mert Sakarya wrote:
> Hi Shyam,
>
> I've had your book, and it worth every penny. Thanks.
>
> Although I liked Joe's way better. Because the next day the same
> subscription works again.
>
> Weird thing is that, the "Notification Services" is hard to getting used to,
> but once one gets the logic behind it, one doesn't anything else for
> notification needs.
>
> "Shyam Pather [MSFT]" <spather RemoveThis @online.microsoft.com> wrote in message
> news:eM9%2329wCFHA.392@TK2MSFTNGP14.phx.gbl...
>
  >>Typically, I create a test program that simply creates a new scheduled
  >>subscription for two-minutes from "now". Whenever I want to test
  >>something,
  >>I run this program to enter a new subscription, then run the app to see
  >>what
  >>happens. You can of course adjust the two-minutes to something longer or
  >>shorter if desired.
  >>
  >>Chapter 6 of my book
  >>(http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/) has a section
  >>on
  >>testing scheduled subscriptions this way.
  >>-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.
  >>---------------------------------------------
  >>"Joe Webb" <joew RemoveThis @webbtechsolutions.com> wrote in message
  >>news:O8cuk8VCFHA.3940@TK2MSFTNGP11.phx.gbl...
  >>
   >>>Mert -
   >>>
   >>>If you're talking about testing scheduled subscriptions, then you can
   >>>create multiple subscription throughout the day. For example the
   >>>following c# code snippet would create a scheduled subscription for
   >>>every minute of today.
   >>>
   >>>for (int hr = 1; hr < 24; hr++)
   >>>{
   >>>for (int mn = 1; mn < 60; mn++)
   >>>{
   >>>nsSubscription.ScheduleStart = "TZID=360:20050202T" +
   >>>hr.ToString("00") + mn.ToString("00") + "00";
   >>>nsSubscription.Add();
   >>>}
   >>>}
   >>>
   >>>Notice that this does not actually set the recurrence for a single
   >>>subscription to a sub-day frequency; it creates lots of individual
   >>>subscriptions. But should help you to test to make sure your
   >>>subscriptions are working correctly.
   >>>
   >>>
   >>>HTH...
   >>>Joe Webb
   >>>SQL Server MVP
   >>>
   >>>~~~
   >>>Get up to speed quickly with SQLNS
   >>>http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
   >>>
   >>>
   >>>
   >>>Mert Sakarya wrote:
   >>>
   >>>>Is there an easy way to test scheduled events or I have to wait at
   >>>>least
  >>
  >>one
  >>
   >>>>day for them to fire?
   >>>>
   >>>>Modifyin time doesn't help much. I think it messes the Quantum time.
   >>>>
   >>>>I got this eventlog error when I did that...
   >>>>Message: 4016: The quantum end time is later than the current real
   >>>>clock
   >>>>time. Notification Services cannot process events that occur in the
  >>
  >>future.
  >>
   >>>>Procedure: NSScheduleQuantum1
   >>>>
   >>>>Line Number: 151
   >>>>
   >>>>
   >>>>
  >>
  >>
>
>