Schedule SSIS Through Web Application

Question

Does anyone know of a good way for a user to be able to specify the schedule for a SSIS package through a web application? The package will run once a day, but the user needs to be able to configure the time that it will run. i.e. every day @ 7am or every day @ 8am etc.

Answer 1

You use SMO to manage the SQL Server Agent, which is what you use to schedule an SSIS package (or packages). Use the JobServer object to get started.

You may want to create the job manually in SQL Server Management Studio, then just use SMO to adjust the schedule.