views:

206

answers:

1

Is it possible to specify two arguments to CmdExec in SQL JOb Step?

I have MyApp.exe Para1 Para2

but it only recognize para1.

A: 

You can check in sysjobsteps to see what SQL Server stores as the command.

If it says "MyApp.exe Para1 Para2" then it means Para2 is probably not recognised by myApp.exe

gbn
in mYApp.exe it only args(1) gives index out of bound errorsit does see args(0) as Para1This is in .NET console app. so: 1) MyApp.exe is being executed2) It sees at least the first parameter
Vilasack Phothisan
@Vilasack Phothisan: you have no checked what SQL Serve Agent is storing. It may not send the 2nd parameter for example.
gbn