Trapping errors in Event subscription rule -- sql server notification services

sudhakar
4/22/2006 6:31:09 AM

Hi all,

I am using a stored procedure for my event subscription rule. This
procedure essentially inserts data into Notifications view by selecting
data from the chronicle tables.
My code is now freezed including the ADF,ICF and stored procedure .

The problem I am having is with my deployment.

With the same set of files, deployment works some times and doesn't
some other times.
I go debugging and find that when things do not work, the statements
within my event subscription rule. are not executed.

I am not using any EventSubmit<ClassName> procedures from within my sp.
The reason being the same procedure works , say 2 out of 4 attempts to
install new NS instances.

Any way to figure out whats going wrong when things are'nt working?

Thanks in Advance

sudhakar

Joe Webb
4/25/2006 12:00:00 AM

Anything in the event log? For more info on how configure the logging
levels, set
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/ba1164a1-b965-48ff-9b86-da92f519be54.htm
in BOL.

HTH...

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
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 22 Apr 2006 06:31:09 -0700, "sudhakar"
[quoted text, click to view]

kate
4/26/2006 3:32:15 AM

is it the deployment (eg instance creation) that if failing ? if so ,
could you describe how and to where you are deploying ?

kate

sudhakar
4/29/2006 7:15:05 AM

Hi All,

Got it resolved !!

Problem was with the firing of the subscription rules. I have multiple
event classes, but have only 1 subscription rule. I tied the rule to
one of the event classes. So the rule was firing only when I have new
data entering that event class.

To overcome this, I created a dummy event class and tied the event rule
to this class and inserting a dummy record into this class every time I
run my event generation logic.

regards
sudhakar

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server notification services

sql server notification services : Trapping errors in Event subscription rule