jsmorris wrote:
> This is the second time this has happened to me in my production system
> (SQL NS 2.0: v2.0.2114.0), so I hope someone here can help as I have
> hit a wall to why this happens.
>
> I have a hosted SQL event provider that is scheduled to run every seven
> days. The configuration is this:
>
> <HostedProvider>
> <ProviderName>WspwProductWithNoBER</ProviderName>
> <ClassName>SQLProvider</ClassName>
> <SystemName>%_NSSystem_%</SystemName>
> <Schedule>
> <Interval>P7DT00H00M00S</Interval>
> </Schedule>
> <Arguments>
> <Argument>
> <Name>EventsQuery</Name>
> <Value>...</Value>
> </Argument>
> <Argument>
> <Name>EventClassName</Name> <Value>...</Value>
> </Argument>
> </Arguments>
> </HostedProvider>
>
> Two times now, the collection of events have gone from weekly to being
> collected every couple of minutes!! Since all my subsriptions are
> event based, users get flooded with email notifications when this
> happens.
>
> My workaround to this problem is
>
> 1) Disable all subscriptions
> 2) Recycle SQL NS windows service
>
> Once I do this, things seem to be corrected and the event collection
> happens as it should once per week.
>
> I would like to know if anyone else has seen this and has a better
> solution?
>
> Is this a known problem?
>
> Will upgrading to 2.0 sp1 help? Nothing in the readme incdicates that
> it would.
>
> Does anyone have better diagnostic steps to trobuleshoot this problem?
> Everything that I have tried looks correct.
>
> Thanks, Jason