topic Python Script not executing as sheduled in a .bat file in Developers Questions

Python Script not executing as sheduled in a .bat file

wwnde — Wed, 30 Oct 2019 05:24:45 GMT

I have a script that runs well and as scheduled on a pc. It cant however be executed when scheduled on the server. It starts of and indicates it is complete within 2 seconds

Looked at all options discussed in this forum. Not able to resolve issue though. Last I tried to use is ESRI Support- Scheduling Tasks and cant seem to understand what the highlighted below is and where it needs to be put in the task scheduler.

Would highly appreciate help.

Re: Python Script not executing as sheduled in a .bat file

CCWeedcontrol — Wed, 30 Oct 2019 20:21:21 GMT

If you layers in are an sde database you might need to include the full path of the layer in your script.

From

Database Connections\Geodatabase_blah_blah.sde

C:\Users\blah\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\Geodatabase_blah_blah.sde\featuredataset\feature class.

Re: Python Script not executing as sheduled in a .bat file

wwnde — Thu, 31 Oct 2019 03:23:09 GMT

This script downloads a feature service from ArcGIS online and saves it to

a local server. So not an SDE database.

Re: Python Script not executing as sheduled in a .bat file

CCWeedcontrol — Thu, 31 Oct 2019 17:41:25 GMT

I would check to make sure you have the full UNC path to the server.

\\\\server\\folder\\folder\\

And you might consider using, scheduler has to have the full server path. At least that is the case for me.

pyodbc.connect

import pyodbc

conn = pyodbc.connect('Driver={SQL Server};' 'Server=server_name;' 'Database=db_name;' 'Trusted_Connection=yes;')

Re: Python Script not executing as sheduled in a .bat file

MichaelVolz — Thu, 31 Oct 2019 19:12:24 GMT

Is this your first attempt at running a python script from a bat file? If so, maybe you want to start with a simpler script than downloading a feature service from AGOL to a local server as there might be multiple issues with a more complex script. Once you get the simple script to execute as expected, than add the more complex code.

Does you server have access to the internet? Due to security issues at my org, internet access is no longer allowed by default for servers. Not sure this applies to you, but something to check with your IT staff.

Re: Python Script not executing as sheduled in a .bat file

JoeBorgione — Thu, 31 Oct 2019 19:43:04 GMT

Why not just run it as a python file not as a .bat file?

Optionally, you can execute the flavor of python .exe you want in the Program/script window, and call the .py file as an argument...

Re: Python Script not executing as sheduled in a .bat file

wwnde — Fri, 01 Nov 2019 04:03:00 GMT

The server has internet connection. Multiple other python 2 scripts running well. Issue was new script runs on python 3, I changed to redirect the exe file to 3 and that is causing issues.

Re: Python Script not executing as sheduled in a .bat file

wwnde — Sun, 12 Dec 2021 02:29:09 GMT

Optionally, you can execute the flavor of python .exe you want in the Program/script window, and call the .py file as an argument...

Quoted suggestion seems to work. I ran the ESRI's given code below

import sys
import platform
import imp

print("Python EXE : " + sys.executable)
print("Architecture : " + platform.architecture()[0])
print("Path to arcpy : " + imp.find_module("arcpy")[1])

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

and it pointed me to the following exe file

When changed to:\python.exe, it all went fine. I too think, it was executing in cd and not in the background (within task scheduler when logged off the server) because I had input mapped directory paths as opposed to the full directory paths.