Jason Wang wrote:
> Thanks for your reply. If the Event Chronicle Rules was processed before
> Scheduled Rules, then I should see an entry in WeatherEventsChron table no
> matter scheduled suscription time was up. However, I did not see anything in
> the table. And because the table was empty, no notification would be
> generated according the scheduled rule:
> <ScheduledRule>
> <RuleName>WeatherSubscriptionsEventRule</RuleName>
> <Action>
> SELECT dbo.WeatherNotificationsNotify(s.SubscriberId, s.DeviceName,
> s.SubscriberLocale, e.City, e.Date, e.Low, e.High, e.Forecast) FROM
> WeatherEventsChron e, WeatherSubscriptions s
> WHERE e.City = s.City
> </Action>
> </ScheduledRule>
>
> Anyway, I manged make it worked last night. The problem was caused by
> DayLightTimeSaving.
>
> "Joe Webb" wrote:
>
>
>>Hi Jason -
>>
>>The generator fires on a schedule according the the QuantumDuration
>>element of <ApplicationExecutionSettings> node. When it fires, it
>>processes the Event Chronicle Rules, Event Rules, and Scheduled Rules in
>>that order (assuming your not using sub-quantum processing).
>>
>>What event provider are you using? FSW or SQLServerEP?
>>
>>Consider turning on verbose logging in the NSService.exe.Config to see
>>if that'll provide any additional information in the Windows Event Log.
>>
>>
>>HTH...
>>Joe Webb
>>
>>~~~
>>Get up to speed quickly with SQLNS
>>http://www.mannpublishing.com/Catalog/BookDetail.aspx?BookID=6
>>
>>
>>
>>
>>Jason Wang wrote:
>>
>>>Someone please tell me when does an event chronicle rule fire? I could not
>>>find it anywhere. I'm having problem on one of my mahines. The weather sample
>>>is not working. After I added subscription, then added an event, no
>>>notification generated. I noticed no entry was in WeatherEventsChron table.
>>>The same config file and adf file works fine on another machine. I am not
>>>sure if the rule fire when an event is added or if it only fires when the NS
>>>server time meets a subscription schedule time?