topic Re: Task scheduler with batch file running python script in Python Questions

Task scheduler with batch file running python script

JamesStout101 — Thu, 14 Oct 2021 14:55:52 GMT

Have created a script and a batch file to run the process automatically.

Pywin opens the script does not"

Any help in getting it to open and execute would be appreciated.

Batch file as follows

C:\Python27\ArcGIS10.6\Lib\site-packages\pythonwin\Pythonwin.exe
C:\Users\jstout\Desktop\PY\MorningProcess\morningprocess.py
Timeout 15

Script as follows

import arcpy, arceditor, time, smtplib

# Set the workspace
arcpy.env.workspace = r'C:\Users\jstout\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\EED_FM@SDE.sde'

# Set a variable for the workspace
adminConn = arcpy.env.workspace

database = "Database Connections/toolboxDEFAULTVersion.sde"
versions = arcpy.ListVersions(adminConn)

# Print the versions available to the user
for version in versions:
print(version)
print "Version list complete."

# Execute the ReconcileVersions tool.
# Use a list comprehension to get a list of version names where the owner
# is the current user and make sure sde.default is not selected.
print 'Reconcile versions started.'

verList = [ver.name for ver in arcpy.da.ListVersions() if ver.isOwner
== True and ver.name.lower() != 'sde.EFAULT']

arcpy.ReconcileVersions_management(adminConn, "ALL_VERSIONS", "SDE.DEFAULT", "", "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_TARGET_VERSION", "POST","DELETE_VERSION")

# Write messages to a Text File
txtFile = open("c:\\temp\\GPMessages.txt","w")
txtFile.write (arcpy.GetMessages())
txtFile.close()

print ('see error log at "c:\temp\GPMessages.txt"')
print'Reconciling Complete'

# Run the compress tool.
print("Running compress")
arcpy.Compress_management(adminConn)

# Use a connection file to create the connection
print "Check state ID"
egdb = r'C:\Users\jstout\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\EED_FM@SDE.sde'
egdb_conn = arcpy.ArcSDESQLExecute(egdb)

table_name = 'EED_FM.sde.sde_States'
field_name = 'state_id'

sql = '''
SELECT {0}, COUNT({0}) AS f_count FROM {1}
GROUP BY {0}
ORDER BY f_count DESC
'''.format(field_name, table_name)

egdb_return = egdb_conn.execute(sql)
for i in egdb_return:
print('{}: {}'.format(*i))
print "State count complete"

# Update statistics and indexes for the system tables
# Note: to use the "SYSTEM" option the user must be an geodatabase or database administrator.
# Rebuild indexes on the system tables
print("Rebuilding indexes on the system tables")
arcpy.RebuildIndexes_management(adminConn, "SYSTEM")

# Update statistics on the system tables
print("Updating statistics on the system tables")
arcpy.AnalyzeDatasets_management(adminConn, "SYSTEM")

print("Finished.")

Re: Task scheduler with batch file running python script

jcarlson — Thu, 14 Oct 2021 15:29:56 GMT

Does the script run manually? Are you getting any error messages?

Re: Task scheduler with batch file running python script

JamesStout101 — Thu, 14 Oct 2021 15:49:22 GMT

The script does run manually. I can open it in py win and run it runs ok. The problem is making it run on a scheduled task.

Re: Task scheduler with batch file running python script

jcarlson — Thu, 14 Oct 2021 16:03:49 GMT

I am not familiar with py win, so I'm not sure how that may or may not be playing into things.

When your batch script calls the .py file, how does py win know to look for that? Should the script's filepath be an argument on the same line, after opening the program

For what it's worth, we use conda, and schedule our scripts as follows:

call c:\ProgramData\Anaconda3\Scripts\activate.bat conda activate <env-name> && python <script-filepath>

Re: Task scheduler with batch file running python script

DominicRobergeIADOT — Thu, 14 Oct 2021 16:56:53 GMT

Perhaps you could try this format in your BAT file:

"C:\Python27\ArcGIS10.6\python.exe" "C:\Users\jstout\Desktop\PY\MorningProcess\morningprocess.py"

Re: Task scheduler with batch file running python script

JoeBorgione — Thu, 14 Oct 2021 17:05:03 GMT

I've never been able to get a scheduled task to execute properly from a desk top computer; only a server. These other responses sound like great suggestions.

Re: Task scheduler with batch file running python script

JamesStout101 — Thu, 14 Oct 2021 17:21:14 GMT

Placing the argument on same line opened the script it does not execute.

PyWin and the script both open task doesn't run.

Re: Task scheduler with batch file running python script

JamesStout101 — Thu, 14 Oct 2021 17:28:14 GMT

Command prompt sits there nothing runs. The command shows in the window as above.

Re: Task scheduler with batch file running python script

DominicRobergeIADOT — Thu, 14 Oct 2021 17:32:34 GMT

humm interesting. Can You open the py file using the IDLE try to run it see if you are getting any error messages. (right click on the file and select Edit with IDLE). I use this all the time and it works on desktop and servers

Re: Task scheduler with batch file running python script

JamesStout101 — Thu, 14 Oct 2021 17:56:10 GMT

Error

Traceback (most recent call last):
File "C:\Users\jstout\Desktop\PY\MorningProcess\MorningProcess.py", line 1, in <module>
import arcpy, arceditor, time, smtplib
ModuleNotFoundError: No module named 'arcpy'

Re: Task scheduler with batch file running python script

DominicRobergeIADOT — Thu, 14 Oct 2021 18:06:44 GMT

look at this link in the Paths and import section

https://desktop.arcgis.com/en/arcmap/10.6/analyze/python/importing-arcpy.htm

Re: Task scheduler with batch file running python script

JamesStout101 — Thu, 14 Oct 2021 18:13:50 GMT

Using 10.6 have none of these lines.

Re: Task scheduler with batch file running python script

DominicRobergeIADOT — Thu, 14 Oct 2021 18:18:47 GMT

you still should have C:\Python27\ArcGIS10.6\Lib\site-packages

then open the Desktop10.6.pth with notepad

I am using 10.8 and got this

C:\Python27\ArcGIS10.8\Lib\site-packages\Desktop10.8.pth

Re: Task scheduler with batch file running python script

MikeVolz — Fri, 17 May 2024 14:38:50 GMT

Dominic:

Have this migrated this script to use ArcGIS Pro's version of python as compared to ArcMap's version of python?

Re: Task scheduler with batch file running python script

DominicRobergeIADOT — Fri, 17 May 2024 19:18:31 GMT

@MikeVolz ,

I use the following line to run python script using AGS Pro and task scheduler

Re: Task scheduler with batch file running python script

MikeVolz — Mon, 20 May 2024 13:36:54 GMT

Dominic:

I have tried this technique besides calling a custom bat file thru Windows Task Scheduler and the import arcpy call using python 3.x installed with Pro randomly crashes. As such this is not a reliable solution for my org.