Post reply

How to schdule DTS job with task scheduler in xp

  • October 29, 2007 at 5:41 am

    #199510

    Does anyone know how to schedule DTS to run in XP, I want to update a table in sql server express every night.Thanks

  • October 29, 2007 at 6:09 am

    #746204

    Go to Management Studio > Object Explorer > Server Explorer > Management > Legacy > Database Maintainance Plans

    Right click on the package & select schedule package....

    --Ramesh

  • October 29, 2007 at 7:43 am

    #746246

    I'm using SQL server Express which does not have a scheduler which is why I want to use the task scheduler in xp

  • October 29, 2007 at 7:51 am

    #746251

    You can get the management tool for SQL Express also. If this is not possible, then you need to create a batch file that runs dtexec command line utility.

    --Ramesh

  • October 29, 2007 at 8:17 am

    #746262

    Thanks Ramesh I got it to work by creating a batch file that runs the dtexec command

  • October 29, 2007 at 9:54 am

    #746302

    Its my pleasure...

    --Ramesh

Viewing 6 posts - 1 through 6 (of 6 total)

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