Step 4: Schedule the Package for Automatic Execution

  • Article

In this task, you will use SQL Server package scheduler to schedule the package to run automatically.

  1. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.
  2. Expand Data Transformation Services, and then click Local Packages.
  3. Right-click your package, and then click Schedule Package.
  4. 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, the number of months between package executions, or select the week and day of how many months for package execution.
  5. 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.
  6. In the Duration section, set a start date, and then select an end date from the drop-down calendar, or select No end date.
  7. Click OK.

The package is scheduled. Remember to check the Task History frequently for failed tasks. For information about using Task History, see Checking for DTS Execution Errors.

Copyright © 2005 Microsoft Corporation.
All rights reserved.