Run extenal program

  • You could run any .EXE as follows using xp_cmdshell :

    xp_cmdshell'c:\winnt\system32\ping.EXE'

    .

  • hi mdamera,

    thank for your reply, i forget to mentioned on point i.e i need myprogram.exe to be run asynchronously.Because xp_cmdshell operates synchronously.

    i've though on way to do that, but wonder ??

    i create an OLE Automation, create an instance of this object and call the method to run the program, however, when creating the object from SP, which give me an error

    i'm using sp_OACreate ,please guide

    thanks

  • I am not sure. Other members are most welcome to give few thoughts!!!

    .

  • How about a scheduled job that can get activated on request?

Viewing 4 posts - 1 through 5 (of 5 total)

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