launch a batch file from a scheduled task

• robert shoemaker

  SSC-Addicted

  Points: 441

  More actions

  February 24, 2006 at 1:42 pm

  #111975

  does anyone know how to launch a dos batch file on the local server from the SQL agent?

   

  thanks

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  February 24, 2006 at 1:47 pm

  #623318

  look up xp_cmdshell in bol, the sql job will be an operating system type 

• robert shoemaker

  SSC-Addicted

  Points: 441

  More actions

  February 24, 2006 at 2:03 pm

  #623320

  thanks for you quick reply!