Microsoft KB Archive/286124

= INF: How to Reschedule a DTS Package =

Article ID: 286124

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * 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.

Keywords: kbinfo KB286124

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.