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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-17 : 15:05:44
|
| Naren writes "Is there any way to enable/disable a DTS job from command line? The reason is we have two servers (one prod and other one backup) and a DTS job which pulls data every 5 minutes should only run from one server which is active. If I can do the enable/disable from outside then I can read an ini file which tells me which server DTS job has to be enabled. Any other suggestion welcome. Thanks" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-17 : 15:14:48
|
| Use sp_update_job to disable a job. To do it from the command line you would use osql and execute sp_update_job. Take a look at sp_update_job in SQL Server Books Online. You'll want to use the @enabled input parameter.Tara |
 |
|
|
|
|
|
DTS Job Enable/disable