Post reply

DTS Job Enable/Disable

  • June 11, 2004 at 12:45 pm

    #108385

    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 

  • June 13, 2004 at 3:42 pm

    #510195

    Assuming you're using SQL Server Agent to schedule the jobs, you could run sp_update_job from osql.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • June 14, 2004 at 6:39 am

    #510243

    Thanks. Great Idea!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply