Executing Exe files from SQLServer

• Helder Martins

  Valued Member

  Points: 54

  More actions

  January 20, 2004 at 3:33 am

  #107707

  Does anyone knows how to execute a exe file from SqlServer ( Stored Procedure / Dts / Job ) ?

  Thanks

  HM

  
  Helder Martins

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 20, 2004 at 3:45 am

  #490781

  Take a look at xp_cmdshell in BOL.

  The example there

  exec master.dbo.xp_cmdshell 'dir *.exe'

  shows the results from the server directory, not your local computer.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Ridok

  SSC Veteran

  Points: 290

  More actions

  January 20, 2004 at 1:55 pm

  #490905

  here another tips...

  --T-SQL

  declare @retval int

  exec @retval = master.dbo.xp_cmdshell 'c:\program files\myapp\myapp.exe'

  print @retval

  if @retval = 0 then the execution was succefully

  -- JOB

  You may use Operating System Command (CmdExec) option from 'Edit Job Step' windows

  or You may use T-SQL option and use the same first sample (xp_cmdshell), but, in that case don`t have a result of execution. Results for execution of job, always be succefully in tha case

   

  --DTS

  You may use the 'Execute Process Task' object

  :.::.:.::