Based on the guidelines in below quoted message, all is set up. The VC job calls the proper script file and executes etc, but it always fails (error message below). When I execute the script.py from the server where VC is installed using Command Prompt, all works fine.
VC is installed on AppsProd server.
Script.py is on ScriptsFS file server.
On the VC job here are the command/params:Command: C:\Program Files (x86)\Python37-32\Python.exe
Arguments: \\ScriptsFS\Public\Script.py
The job does execute, but fails with this error: Traceback (most recent call last):
File " \\ScriptsFS\Public\Script.py", line 7, in <module>
import openpyxl
ModuleNotFoundError: No module named 'openpyxl'
Exception in Task: Non zero exit code
Exit code (1) description: Incorrect function.
On AppsProd, if I execute this, it works fine: c:>\\ScriptsFS\Public\Script.py
Absolutely lost. Any help is appreciated!
I think it is as simple as described:
1. use Execute Task
2. in command field use full path to python.exe on your computer, for example; c:\python\python.exe
3. in argument field use full path to your script then arguments, for example; c:\myscripts\script.py argument1 argument2
Let us know if this does not work.