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,
YanivWithin 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.|||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...
>