Create a web service to co ordinate data Uploads from 200 different machines

A

AG

I have about 200 different machines where I have configured jobs to
upload small amounts of data to a central sql server.I want to give
clients the option to enter the time when they want these packages
executed and have a web service which kicks offf the jobs at the
sceduled time and email sucess and failure to the client and the help
desk.

Would . net be the best way to do this where i capture the times from
the clines when they want the job executed in the table and execute
sp_start_hjob on each machine using OSQL.
Each job would run approx 5 mins.

Thanks in anticipation.

Are there any other options?



Ajay Garg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,997
Messages
2,570,240
Members
46,828
Latest member
LauraCastr

Latest Threads

Top