INF: How to Reschedule a DTS Package (286124)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q286124

SUMMARY

If you have configured a Data Transformation Services package to execute on a schedule, you may modify the schedule by using SQL Server Enterprise Manager. However, do not change the schedule for the package by using the Schedule Package command available in the context menu when you right-click the package.

MORE INFORMATION

The first time you schedule any package, a SQL Server job is created to run the package. The schedule you create is not associated with the package, but with the job used to execute the package. If you use the Schedule Package command multiple times in an attempt to modify a schedule that you have already created, you create multiple jobs, with each job running the same package on a different schedule. The dialog that appears as a result of clicking Schedule Package after a package has already been scheduled does not display the schedule you have already created. Instead, it shows default values.

When you need to reschedule a package, follow these steps:
  1. Open the SQL Server Enterprise Manager and navigate to the Jobs item associated with your server. To find the job list, open the Management folder, click SQL Server Agent, and then select Jobs.
  2. Examine the job list and find a job with the same name as your package.
  3. Double-click the job. When the Job Properties dialog box opens, click the Schedules tab.
  4. Select the schedule you want to change, and then click Edit.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbinfo KB286124
©2004 Microsoft Corporation. All rights reserved.