I am trying to see if SQLNS will be able to help with an application I was
going to write from scratch. The purpose of the application, called the
Scheduling Component (SC), is to enable a wide variety of processes to be
scheduled to run automatically for our product suite. The scheduling
component needs to provide for an extendable method of calling external
processes. In the beginning this component will be configured to run 2 types
of processes. The first being a stored procedure and second a web service.
In addition, it would be good to have the ability to query database to
determine the value to pass for the schedule’s parameters.

So basically, I want to be able to set up schedules that will execute a
stored procedure or make a call to a web service passing it parameters. Will
SQLNS support this?

Thanks in advance for your help!

Hi Scott -

The context for which SQLNS was designed is one where there are
subscribers interested information that you have, events that supply
that information to your system, and the result is notifications are
produced to inform the subscribers of events information.

SQLNS is certainly extensible and you can create custom delivery
protocols that will call a web service for you or execute a stored
procedure in some database. You could also manufacture events to meet
your scheduling needs. But, I suspect that unless there is a
compelling reason to use SQLNS that you haven't mentioned that a
custom application may be better suited for your scenario.

Just my initial impression based on your description.

HTH...
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 Wed, 18 May 2005 14:40:05 -0700, "Scott" <Scott
[quoted text, click to view]