'lprun' is not recognized as an internal or external command, operable program or batch file

I have a script which runs fine on its own but when I put it in SQL Job Agent on a batch file, I get the error above:

This is what goes in my batch file:
lprun -format=csv C:\AUTOMATION\Jobs\Job1.linq > Job1.csv


This is the full error . . . .

Message
Executed as user: SYS\User1. C:\Windows\system32>lprun -format=csv C:\AUTOMATION\Jobs\Job1.linq 1>Job1.csv 'lprun' is not recognized as an internal or external command, operable program or batch file. Process Exit Code 1. The step failed.


Any ideas what I may be doing wrong?

Many thanks.

Comments

  • You either need to provide the full path to lprun.exe, or ensure that it's in the environment path for SQL Job Agent.
  • I'm not allowed to mess about with the variables, but putting in the full path did the trick: EG:

    "C:\Program Files (x86)\LINQPad5\LPRun.exe" -format=csv C:\AUTOMATION\Jobs\Job1.linq > Job1.csv

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!