Run Python script through Windows Task Scheduler

MathieuCain

Hello,

I have a number of Python scripts (exported models from Model Builder), which I would like to get run automatically at a particular time/day of the week. I had hoped I could run the scripts through MS Access so as to bundle them up with a number of other procedures that happen first there, and then schedule a basic MS Access macro to run through Windows Task Scheduler. Unfortunately, I have had limited success in getting the scripts to run through Access ShellWait.

I would appreciate your help.

Thanks.

mvolz47

I would create a bat file such as this that would call the python script(s) that you created.  I have additional documentation that is sent to the log file to help indentify when each script is being run.  Just give it a file name such as Update.bat


@echo off
echo Start time: %time% > update_data.log

echo ------------  Start time: %time%
echo ------------  Refreshing Database  -----------------------
echo ------------  Refreshing Database  ----------------------- >> update_data.log
01_Data.py >> update_data.log

echo End time: %time%
echo  ' ' >> update_data.log
echo End time: %time% >> update_data.log
@echo on

I hope this helps.