How to run python script in scheduler?

Question

Python

Hi everybody!

I have a simple script that parses an XLSX file and generates some CSVs using the openepyxl library. I made an EXE out of it using the pyinstaller library to run on a non-Python machine using the task scheduler.

Problem: if you run the exe-file or script manually, then everything works fine. If you run the same script or exe through the Windows scheduler, then the task does not work, and the result of the execution is 0xFF. The task runs under the service user, there are rights to run it. If you set the option "Run only when the user is logged into the system" in the scheduler settings, then everything works, if you set the launch option regardless of whether the user is logged in or not, then nothing works.

Has anyone experienced something similar? Apparently, the library requires interactivity from the session.

Answer 1

the path to the python and to the file are absolute
inside the script all paths are absolute