all groups > sql server notification services > august 2005 >
You're in the

sql server notification services

group:

ScheduledRule and NSControl Update



ScheduledRule and NSControl Update SVA
8/8/2005 5:30:54 AM
sql server notification services: I wonder if the following is a known problem:

Essentially, it seems there is no way to add a schedule rule to an
existing subscription class in ADF file. NS update runs without errors,
but no schedule-related tables and fields are created.

Yet NS documentation says that "<ScheduledRules> node ... Can be added
and deleted using NSControl Update."


In particular, if you add a <ScheduledRule> node to your Subscription
class (located in ADF file) and run NSControl Update, it creates
NSXXXSubscriptionsSchedules table for the given Subscription class.

That is fine.

However, it works only if you create a new subscription class from
scratch.

If you add <ScheduledRule> rule to the existing Subscription class
(located in ADF file) via NSControl Update, then no
NSXXXSubscriptionsSchedules table is created.

Is this by design?

Thank you in advance.

Regards,
Vladislav.
Re: ScheduledRule and NSControl Update Shyam Pather [MSFT]
8/8/2005 2:45:07 PM
Vladislav,
The schedules table is created on a per-subscription class basis, not on a
per-rule basis. Therefore, if you already have one or more scheduled rules
in the subscription class and then you add another, you will not see
additional schedules tables added. The new rules will use the existing
schedules table.
-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]

Re: ScheduledRule and NSControl Update SVA
8/9/2005 2:52:48 AM
Shyam,

Thank you.

My situation is a bit different, though:

Initially, I have no scheduled rules at all.
Then, I add one.

In this case, no schedule tables are created at all.
Also, scheduleID column is not created in
NSXXXSubscriptionsSubscriptions table.


Regards,
Vladislav
Re: ScheduledRule and NSControl Update Joe Webb
8/25/2005 4:57:25 PM
On v2.0 SP1 or 2005?


--
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 9 Aug 2005 02:52:48 -0700, "SVA" <uspexpress@unisoftplus.com>
[quoted text, click to view]
Re: ScheduledRule and NSControl Update SVA
8/26/2005 7:31:04 AM
On v2.0 SP1
AddThis Social Bookmark Button