We have a set of jobs in sql server agent in SSIS 2005. Do you know
how to execute them from a web browser. Or for that matter, how to
execute them from our client side. I have multiple databases with the
same set of jobs, how do I invoke these jobs and from where. Any
suggestion is much appreciated.

Thanks in advance.

To execute jobs, check books online for sp_start_job.
http://msdn2.microsoft.com/en-us/library/ms186757.aspx
If these jobs can run on a schedule, you should look at just
scheduling the jobs. You can also run them manually from
Management Studio.

-Sue

On 6 Mar 2007 09:03:45 -0800, "swetha"
<swetha.sankaran@gmail.com> wrote:

>We have a set of jobs in sql server agent in SSIS 2005. Do you know
>how to execute them from a web browser. Or for that matter, how to
>execute them from our client side. I have multiple databases with the
>same set of jobs, how do I invoke these jobs and from where. Any
>suggestion is much appreciated.
>
>Thanks in advance.