sql server notification services: Hi,

One issue I am facing with SQL Server Notifications is=20

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.=20
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.=20

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

<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)=20

FROM PersonSubscriptions s, PersonEvents e



--Insert symbol if not already in the chronicle=20

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=20

</Action>

<EventClassName>PersonEvents</EventClassName>=20

</EventRule>

</EventRules>



Waiting for your earliest response.=20

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.
---------------------------------------------
[quoted text, click to view]
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

How are you submitting events when the service is stopped? Are you
using the event stored procedures?


--
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



On Sun, 7 Aug 2005 09:09:31 +0530, "Yogesh K."
[quoted text, click to view]