Ssis package or sql job from web

SQL Server Administration
1

Hi There,

I have master ssis package to kick off other ssis packages, then job is set up to run master package on schedule basis.

Is there any way I can set up intranet page, so user can run the job or ssis package at ad hoc basis.

Thanks

2

sure, there is a series of procs you can use to kick off a job. see here

3

gbritton,

Thanks for the link, will check it out, I am thinking about something like asp.net app to call sql agent job.

4

yeah that;s not a bad approach