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

Re: Something I don't understand.

Subject: Re: Something I don't understand.
From: Joe Webb
Date: Mon, 30 Jan 2006 11:44:29 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Bob - 

To create a new SQLNS instance you've got a couple of options. 

1) you can take one of the existing sample apps, remove all their
logic, and replace it with your own logic. This is typically what I
do.

2) you can essentually automate option #1 by using the CopySample
command to copy an existing sample instance. 

3) you can develop from scratch. Both Shyam and I describe how to do
this in our books. 

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 Wed, 25 Jan 2006 11:47:20 -0500, "Bob" <[email protected]> wrote:

>Thanks Joe,
>I'm stuck for the time being with utilising sql server 2000, because that's 
>what the customer's 'new' application uses (developped by another company).
>In any case, thanks for your insights.
>In the docs and samples they show you existing complete app but nowhere did 
>I find instructions on how to proceed step by step from scratch, except 
>possibly in a fairly high level lingo that's not at all clear to a newbie 
>like me.
>Do you know of any place where I can find such information?
>
>Bob
>
>"Joe Webb" <[email protected]> wrote in message 
>news:[email protected]
>> Hi Bob -
>>
>>>I'm looking at the notification services docs and I
>>>see that the subscribers database needs to be created and the subscription
>>>tables get created by executing command and and or XML files and all this
>>>underlying databse and underlying tables get created like in the samples.
>>
>> That's true. SQLNS is a develoment framework so you cannot really pick
>> and choose what portions you'd like to implement. However, in many (or
>> most) cases you can pretty easily integrate SQLNS into your existing
>> process with little duplication. For instance, since you already have
>> your data in a specific table, you can use that information as the
>> basis for your events. You don't have to submit all the data to the
>> SQLNS tables, only a primary key for your table and let the SQLNS join
>> to it later on in the notification process.
>>
>> Additionally with SQLNS 2005, we can opt to have all the SQLNS-related
>> database objects to be created in our existing databases. I discuss
>> this option here
>> (http://sqlns.blogspot.com/2006/01/using-existing-database-for-our-sqlns.html).
>>
>> 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 Tue, 24 Jan 2006 17:41:52 -0500, "Bob" <[email protected]> wrote:
>>
>>>Well lots of things really but anyways ;-)
>>>I have an existing app using sql server 200 tables. One of the tables is
>>>DeliveriesToBeMade, in it I have all the information about a scheduled
>>>delivery (whoto, when, what, HowToNotify - phone or e-mail, phone number
>>>e-mail address etc.)  I'm looking at the notification services docs and I
>>>see that the subscribers database needs to be created and the subscription
>>>tables get created by executing command and and or XML files and all this
>>>underlying databse and underlying tables get created like in the samples.
>>>Fine, but I already got the subscribers. Its my customer list and we don't
>>>want to create an parrallel data entry system for stuff we already have.
>>>There's already an app doing that.
>>>I already have the DeliveriesToBeMade, every time a new delivery is
>>>scheduled in the existing app a new record is created here and it contains
>>>all the info I need to pass to the subscriber. I want the notifications to
>>>go out twice a day, once at 1630hrs and once at 1830 hours.
>>>
>>>So  question
>>>
>>>It looks like I need to use the automatically generated infrastructure for
>>>notifications services and pass it information I already have in effcet
>>>making duplicates but in another form. Am I right? If yes, how can I do
>>>that. If No, same question :-).
>>>
>>>
>>>Thanks for any insights,
>>>
>>>Bob
>>> 
>

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