SQLTeam.com | Weblogs | Forums

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 asp.net app to call sql agent job.


yeah that;s not a bad approach