Best choice of technology

[JohnFol]

Gregory, sound like that has hit the nail on the head. Could you give me a
pointer ?


"Cowboy (Gregory A. Beamer) [MVP]" <No************@comcast.netNoSpamM> wrote
in message news:%2***************@TK2MSFTNGP10.phx.gbl...

The service can expose certain interfaces that your tool can query, or
continue to query. You can even make the service continually raise events
and subscribe. There are a variety of ways to architect.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"JohnFol" <Wi****@wobble.com> wrote in message
news:uB**************@TK2MSFTNGP12.phx.gbl...

Hi Gregory, and thanks for the suggestions. I think it will be SQL2000, so

it sounds like my monitoring will have to be external to SQL.

A common theme to your reply and Williams' is the concept of interacting
with a service. I've tried the CustomerCommand, but it's a call into the
service and does not return values. Nor can I raise an event from the
service. This would give my UI something to hook into. Looks like I am
missing some key feature of services.

FYI
I aim to create Perfmon entries / counters, but the UI (if running) needs

to

list something like the following:

"12 Jan 2004 10:00:03 Processing Order XYZ"
"12 Jan 2004 10:00:04 Order XYZ sucessfully processed"

. . . you get the gist.

Thanks again for the ideas.
"Cowboy (Gregory A. Beamer) [MVP]" <No************@comcast.netNoSpamM>

wrote

in message news:uK**************@TK2MSFTNGP10.phx.gbl...

For pure processing of data, I would consider creating a DTS task in SQL Server. You can partially monitor it, so it may not be choice #1. In SQL Server 2005, you have more monitoring options.

You can export DTS code to VB and set up a process to figure out where

you are.

With .NET you can make a service that runs these DTS processes. It will have

to use COM interop.

You can also roll your own DTS with a .NET service. The service option is nice, as you can set up hooks to more easily monitor. The executable hooks into the service and checks status, et al.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"JohnFol" <Wi****@wobble.com> wrote in message
news:OE***************@tk2msftngp13.phx.gbl...
> I have a requirement to run some code on a server. The purpose of

the

code

> is purely to process data between an MS SQL box and a remote Oracle

box. It
> has no UI, and needs no user intervention to run.
>
> The 2nd part of the requirement is to have a UI that will allow an
operator
> to view the progress / current status of the processing. Even if the

UI

is

> not loaded, the processing must continue.
>
> I have a few ideas on how to tackle this, but would welcome

opinions. >
> Any ideas most welcome.
>
>