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
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