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
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.
Learn more about SQL-NS:
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
"Yogesh K." <[email protected]> wrote in message
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
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,
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� 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,
FROM PersonEvents e
Waiting for your earliest response.