microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Notifications are not generated

Subject: Re: Notifications are not generated
From: "Shyam Pather [MSFT]"
Date: Mon, 8 Aug 2005 14:42:54 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Because of the way the NS Generator's quantum clock is initialized, events 
submitted before the _first time_ the service is started will never be 
picked up.

After the first time the service is started, if you stop the service, events 
submitted while the service is not running will be picked up once it starts 
again. This can be controlled via the SubscriptionQuantumLimit and 
ChronicleQuantumLimit elements in the ADF.

-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.
---------------------------------------------
"Yogesh K." <[email protected]> wrote in message 
news:%[email protected]
Hi,

One issue I am facing with SQL Server Notifications is

I post the events to Notification Server when the service is not running. 
The events are seen in the NSPersonEventsEvents table under the Application 
database. Once I start the service, no notifications are generated for the 
events I had posted.

But yes, henceforth, when the service is running, all the events posted, 
notifications will be generated.
Only to the one posted when the service was stopped, no notifications are 
generated, even after the service is started. Why doesnt the notification 
server pick-up those events.

Do I need to do any additional configuration.
I am pasting the EventRule provided in subscription. This should be of some 
help

<EventRules>

<EventRule>

<RuleName>PersonSubscriptionEventRule</RuleName>

<Action>

SELECT dbo.PersonNotificationsNotify(s.SubscriberId, s.DeviceName, 
s.SubscriberLocale, e.Version, e.Create_Time, e.Person_Id, 
e.Person_First_Name, e.Person_Last_Name, e.Person_Join_Date, e.Person_Login, 
e.Person_Email, e.Person_Status, e.Current_Status_Start_Time, e.Home_Phone, 
e.Cell_Phone, e.Culture, e.TimeZone, e.Center_Id, e.Sip_Address, e.Password, 
e.Supervisor, e.Support_Level, e.Skills, e.Roles, e.Channel_Capabilities, 
e.IsActive)

FROM PersonSubscriptions s, PersonEvents e



--Insert symbol if not already in the chronicle

INSERT INTO PersonEventsChron (Version, Create_Time, Person_Id, 
Person_First_Name, Person_Last_Name, Person_Join_Date, Person_Login, 
Person_Email, Person_Status, Current_Status_Start_Time, Home_Phone, 
Cell_Phone, Culture, TimeZone, Center_Id, Sip_Address, Password, 
Supervisor&#0; Support_Level, Skills, Roles, Channel_Capabilities, IsActive)

SELECT Version, Create_Time, Person_Id, Person_First_Name, Person_Last_Name, 
Person_Join_Date, Person_Login, Person_Email, Person_Status, 
Current_Status_Start_Time, Home_Phone, Cell_Phone, Culture, TimeZone, 
Center_Id, Sip_Address, Password, Supervisor, Support_Level, Skills, Roles, 
Channel_Capabilities, IsActive

FROM PersonEvents e

</Action>

<EventClassName>PersonEvents</EventClassName>

</EventRule>

</EventRules>



Waiting for your earliest response.

Yogesh Kadalgikar





<Prev in Thread] Current Thread [Next in Thread>