Making changes to DTS packages-Do I have to create a new schedule job?

[ks1392]

Let's say I create a DTS package, save it, then create a schedule for that DTS package. My question is about when I make changes to the DTS package AFTER creating the schedule. Will the schedule still run the original instance of the DTS package for which it was created or will it always run the newest instance of the package?

Thanks,
Kerr

 

[tlbroadbent]

The SQL Agent will run the newest instance of the package. There is no need to create a new job. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ks1392]

Thanks for the clarifiction, Terry!