SQLTeam.com | Weblogs | Forums

Ssis package or sql job from web


#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