MS SQL Server Notification Services - Something I don't understand.

Author

Something I don't understand.

Bob

2006-01-24, 8:24 pm

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

Joe Webb

2006-01-24, 8:24 pm

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/u...-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/t...il/-/0972688811

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

On Tue, 24 Jan 2006 17:41:52 -0500, "Bob" <bdufour@sgiims.com> 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
>

Bob

2006-01-26, 4:58 pm

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" < joew@webbtechsolutio
ns.com> wrote in message
news:jqbdt1psp87s91p
bv976ci6oajfb4dmh2g@
4ax.com...[color=darkred]
> Hi Bob -
>
>
> 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/u...-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/t...il/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
>
> On Tue, 24 Jan 2006 17:41:52 -0500, "Bob" <bdufour@sgiims.com> wrote:
>

Joe Webb

2006-01-30, 1:24 pm

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/t...il/-/0972688811

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

On Wed, 25 Jan 2006 11:47:20 -0500, "Bob" <bdufour@sgiims.com> 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" < joew@webbtechsolutio
ns.com> wrote in message
> news:jqbdt1psp87s91p
bv976ci6oajfb4dmh2g@
4ax.com...
>

Sponsored Links