Stopping/Modifying Schedule DTS Package

[LearningSql]

Hi all --

I've searched through the forum for how to modify a Scheduled DTS Package. I even looked into BOL and SQLDTS.COM. I must using the wrong search term or am just missing it.

How do I modify or stop a DTS Package that I have scheduled to run every day at 6AM?

Thanks to all.

 

[osjohnm]

Hi

To stop a scheduled package go into Enterprise Manager>Management>SQL Server Agent>Jobs>Find the job that executes the package>Right Click>Disable Job
or click Properties to edit the schedule.

To edit packages in Enterprise Manager>Data Transformation Services, Local packages> Find the package> Right click> Design package.

Hope that helps

John

 

[LearningSql]

Thanks osjohnm. Found it with your help.
Have a great week.