Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bobshishka
Yak Posting Veteran
72 Posts |
 Posted - 2007-11-01 : 11:06:35
|
| Im trying to schedule a DTS package that I have created. When I right click on the package in Enterprise Manager and click on "Schedule" I get the options to set up the job to run on a schedule.I fill out the time and click "OK". But when I immediately right click on the package again, all my settings are gone, and the defaults are back in place. How do I know if the package will run- or if it did run?I would actually prefer to run the job from a command line using a Scheduled Task... What would the syntax be? My DTS Local Package is named "IMPORT_DAILY_UPDATE"Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-11-01 : 11:12:41
|
| usually best to schedule from sql agent.syntax is dtsrun /N<package name> /S<server name>in cmd window hit dtsrun /? to see full syntax, all options |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 22:17:05
|
| After setting schedule, you can find the job under sql agent -> jobs in em. |
|
|
|
|
|
|
Schedule DTS