0

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

I have MyApp.exe Para1 Para2

but it only recognize para1.

gbn
  • 422,506
  • 82
  • 585
  • 676
Vilasack Phothisan
  • 1
  • 1
  • 4

1 Answers1

0

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
  • 422,506
  • 82
  • 585
  • 676
  • in mYApp.exe it only args(1) gives index out of bound errors it does see args(0) as Para1 This is in .NET console app. so: 1) MyApp.exe is being executed 2) It sees at least the first parameter – Vilasack Phothisan Apr 07 '10 at 11:06
  • @Vilasack Phothisan: you have no checked what SQL Serve Agent is storing. It may not send the 2nd parameter for example. – gbn Apr 10 '10 at 08:53