|
Home > Archive > MS SQL Server > January 2006 > run an external file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
run an external file
|
|
|
| I am using sql server 2000 sp3a.
How do I start (run) an external file. ie, run a vbs or exe fro Query
Analyzer or from within a job step.
Thanks,
Yaniv
| |
|
| Within a jobstep you can choose that the type of job step is "Operation
System command", put your command in here. Another option would be tu
sue the procedure xp_smdshell which call call the commadn interpreter,
therefore you have to choose TSQL Command execution in the job step.
HTH, jens Suessmeyer.
| |
| Uri Dimant 2006-01-26, 4:53 pm |
| Run vbs file
EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'
> sue the procedure xp_smdshell which call call the commadn interpreter,
xp_cmdshell ? :-)))))))))
"Jens" <Jens@sqlserver2005.de> wrote in message
news:1138186195.161343.91450@g49g2000cwa.googlegroups.com...
> Within a jobstep you can choose that the type of job step is "Operation
> System command", put your command in here. Another option would be tu
> sue the procedure xp_smdshell which call call the commadn interpreter,
> therefore you have to choose TSQL Command execution in the job step.
>
> HTH, jens Suessmeyer.
>
| |
|
| Thank you both.
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:%23YmvfNaIGHA.1424@TK2MSFTNGP12.phx.gbl...
> Run vbs file
> EXEC master..xp_cmdshell 'cscript /nologo c:\file.vbs "stringarg" 5'
>
>
> xp_cmdshell ? :-)))))))))
>
>
> "Jens" <Jens@sqlserver2005.de> wrote in message
> news:1138186195.161343.91450@g49g2000cwa.googlegroups.com...
>
>
|
|
|
|
|