Remote execution of SQL server agent job

• Barathan

  Grasshopper

  Points: 15

  More actions

  June 9, 2007 at 4:53 am

  #153627

  Hi,

  I want to execute a SQL server agent job through a MS-DOS batch file remotely . Wonder how do I do it.

  Thanks and Regards,

  BB.

• Phil C-257913

  SSC-Addicted

  Points: 453

  More actions

  June 12, 2007 at 2:25 am

  #712191

  Run OSQL (or SQLCMD) from the batch file and have it execute an SQL statement which calls sp_start_job.