batch file from scheduled task returns code 2147942401

I am trying to schedule a job to run a batch file with Windows 10 Task Scheduler, but it results in return code 2147942401.

The batch file is on remote location so I am giving the absolute path "\\\server1\file transfers\data files\inbound\abc\csv\excel-to-csv.bat"

enter image description here

enter image description here

If I run the batch script with command prompt then it work fine. Properties - General Actions - Edit Action

The batch script is to convert excel to file to csv.

Content of the script is:

FOR /f "delims=" %%i IN ("\\server1\file transfers\Data Files\Inbound\abc\CSV\*.xlsx" ) DO to-csv.vbs "\\server1\file transfers\Data Files\Inbound\abc\*.xlsx" "%%~ni.csv"
Its calling another VB script which is to-cvs.vbs

If i make changes in Action tab as mention by @Steinspecht(Task scheduler- task completed “successfully” with exit code 0x8007001) then also i am getting the code 2147942401Not sure whether Add a arguments is written correct

2 Answers

I had a similar problem and this_solution helped me. The thing is to separate script name from its path, by using the "Start in" parameter. Just tooo simple.

1

I was getting this error too and what finally resolved it was changing one of the general settings from "Run whether user is logged on or not" to "Run only when user is logged on".

Even if my computer is locked, it will run.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like