Ssis package or sql job from web

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.


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


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

yeah that;s not a bad approach