Step 4: Schedule the Package for Automatic Execution
In this task, you use SQL Server package scheduler to schedule the package to run automatically.
Note
If you are running SQL Server 2005, you must create a SQL Server Integration Services (SSIS) package in order to schedule a package for automatic execution. For more information and instructions about how to create an SSIS package, see https://go.microsoft.com/fwlink/?LinkId=91132.
To schedule the package for automatic execution
Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.
Expand Data Transformation Services, and then click Local Packages.
Right-click your package, and then click Schedule Package.
In the Edit Recurring Job Schedule dialog box, in the Occurs section, click Daily, Weekly, or Monthly.
If you selected Daily, select the number of days between package executions.
If you selected Weekly, select the number of weeks between package executions, and which day of the week to execute the package.
If you selected Monthly, select the day and the number of months between package executions, or select the week and day of how many months for package execution.
If you selected Daily, in the Daily Frequency section, select Occurs once and set a time, or select Occurs every and set an interval, and start and end times.
In the Duration section, set a start date, and then select an end date from the drop-down calendar, or select No end date.
Click OK.
The package is scheduled. Remember to check the Task History frequently for failed tasks.