Python Script Task Scheduler Alternative

deleted-user-RAnIQZ9vH9z7

I have a python script that I would like execute on an interval of every 5 minutes to check a SDE field for a new record.

Our Enterprise Systems team does not allow Windows Task Scheduler to execute Python. Does anyone know an alternative way to have the script executed?

Currently running ArcGIS 10.5.1 on Windows and SQL Server 2014.

Here is what the script does:

1. Connect to SDE
2. Start the arcpy.da.Editor session
3. Open a arcpy.da.UpdateCursor session
4. Look for null values and if there is a null, update it a string value
5. Close the arcpy.da.Editor sesion

The script needs to be run on a server and we are not allowed to use Service Accounts with passwords. We only have Group Managed Service Accounts (gMSA) with no passwords and those are not allowed to execute the python exe.

deleted-user-RAnIQZ9vH9z7

Found the work around. The original ArcGIS blog post says to run the Python exe and in the argument, put the location of the .py file. The Enterprise Systems team says no exe files are allowed to run under the Service Account (gMSA). I rewrote my script to execute as a standalone file. Meaning if python is installed on your machine and you double click the .py file, the script should run without calling an exe. This is Vanilla Python and nicely explained by this video.

With my .py file ready to roll, I scheduled a task on the server to call the .py file and not exe. In the Triggers tab, I was able to schedule a Daily task to run at a specific time. My original requirement was every 5 minutes. The Advanced Settings for the Daily task does not work. The work around I have is set a new trigger every 2 hours instead of every 5 minutes and have the customer accept the solution that the Enterprise Systems team has allowed us to work with. Even that, I will have to schedule 12 separate triggers for the 1 task scheduler.

Either case, thanks for all your comments and suggestions!