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

Aquatarkus

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.

JoeAlbahari

You either need to provide the full path to lprun.exe, or ensure that it's in the environment path for SQL Job Agent.

Aquatarkus

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