Schedule Python Scripts with Windows Task Scheduler | Automate Python scripts

[@olevam1]

Really clear and strong video! I was quite confused by the whole thing

[@loosemouth]

Excellent demonstration!

[@swabhimandalei8991]

Great video man. Crisp and clear. Really appreciate it.Thanks.

[@diegonunez7184]

thank you sir! Great tutorial. Straight to the point and fully intelligible

[@tahirrana786]

Awesome very informative and valuable videos please keep up the good work

[@Mchenjunmin]

Hi, Thanks a lot for the tutorial. I have a question, if you don't mind to answer, my python works , dataframe printed on the command line, however, it doesn't update my csv. Any ideas? Thanks

[@BiInsightsInc]

Hi Danny, without seeing the code I can't really say why it's not updating the CSV. But make sure to check you're writing the dataframe to csv file after printing it. This is how you can write dataframe to file. Hope this helps. df.to_csv('name.csv', encoding='utf-8', index=False)

[@nickd1978]

Fantastic video. Straight forward and concise.

[@Magdoulin]

My file extension is .ipynb not .py, do I need to change it? As it did not run as scheduled. But how to know from the task scheduler if it fails? Because this run failed for sure, but, the task scheduler does not show this.

[@BiInsightsInc]

Yes, you would need a python file for the Windows Task Scheduler. You can convert a Notebook (ipynb) from the Jupyter Notebook UI. File > Download as Python (.py) Also, I have covered how to schedule notebooks via Jupyter Scheduler and Dagster. You can pick whichever suits your needs. Here are the links: Jupyter Scheduler: kzbin.info/www/bejne/n4DNYoSYiZqVgqM Dagster: kzbin.info/www/bejne/ZnPKlHmKm96fY6c

[@rovshanaliyev8164]

Detailed and very clear!!!

[@debradavila-simpson4939]

I am not sure what is going on with my situation. I use "Where py" because my file is in Windows. Script runs fine locally. I did the last part as instructed: py location for program/script, py file name no quotations, and py file location with slash at the end - no quotations. Nothing happens and the results show 0x2. Have no idea what I'm doing wrong within my vm.

[@BiInsightsInc]

I am demonstrating the script on windows as well. There might be errors in the background. You can check the logs to view the actual error. To view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@missmosity]

Thank you so much for making this, it solved my problem!

[@ShivamMishra-jb6jm]

This video helped me a lot. Thanks

[@nitesh8117]

@BI Insights Inc For scheduling task for python script, you copy pasted code from jupyter notebook to a ".py" file. Is there a way to scheduling script directly from jupyter notebook in windows task scheduler with copy paste ?

[@BiInsightsInc]

Hi Nitesh, there are few ways of scheduling Notebooks. Locally I'd use nbconvert to convert the notebook to file and schedule the file. If you want more options then I'd suggest give the following a read. Hope it helps. medium.com/@thabo_65610/three-ways-to-automate-python-via-jupyter-notebook-d14aaa78de9

[@web_dev_host]

Thank you so much, it was very informative.

[@CatZilla1995]

SyntaxError: Missing parentheses in call to 'print'. Did you mean print(...)?

[@BiInsightsInc]

I think the error suggest you are using the print function without the parentheses. So try print(‘Whatever you need to print’)

[@CatZilla1995]

@@BiInsightsInc Thank very much.

[@CatZilla1995]

how do i write code If there is no data in Excel then it will not be sent to the mailbox. Can you recommend me? Thank you very much.

[@BiInsightsInc]

@@CatZilla1995 you need to check if your data frame is empty then do not process the file and send mail. I’m the else part follow your workflow. if df.empty: Print(“No data available”) else:

[@CatZilla1995]

@@BiInsightsInc i can thanks. if resultsAlert.empty == True: output = "Complete no difference" else: output = build_table(resultsAlert) print("Thank very mush") return output 😆

[@Croat955]

great video it helped me a lot

[@allamaprabhuani]

Thanks for this!

[@paulmouatib9999]

Nice tutorial, unfortunatly, my script is working fine in VS Code but refuses to do anything once in the task scheduler. The console window is not even showing and I have a generic error mssage in the tab "history" of the task saying "Fail to launch"

[@BiInsightsInc]

Thanks Paul. You can check the logs to view the actual error. To view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@paulmouatib9999]

@@BiInsightsInc Thanks for your answer, I think your forgot one very important thing in your video, even it the code is working on VS Code, it is highly probable it will not work in the Task Sheduler if you don't install the requirements. After installing them with pip, it works perfectly

[@smart40333]

Hi I was trying to schedule a .py file. However, the cmd console just flashed and closed. I'm pretty sure that the script works since I could run it through spyder, but I can't schedule it. Does anything I can do to solve this problem?

[@BiInsightsInc]

Hi Huang, this is normal as described in the first part of the video . You'll see a console window and it will close right away. If your script runs then you should be able to schedule it. If want to keep the console window open then add below lines to your scripts. To hide the console window you can use the second method shown in the video. print("Press Enter to continue ...") input()

[@Aida-s7f]

my script works fine, but when I tried to schedule it, nothing happens I followed your instructions to the details. why it doesn't run automatically

[@BiInsightsInc]

Hi Aida, thanks for stopping by. You can view the logs and see if the script is producing an error. This will help you troubleshoot the issue. To view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@_schmorf_1339]

Nice video! But i have a problem with my scheduled task. I use docx2pdf for converting my files into PDFs once a month . Running the Job manually, everything is fine. But when i try to schedule the task, i get an DGI Error with the Windowhandler. Any ideas?

[@BiInsightsInc]

Thanks for stopping by. I would say try it with a simple script first to see if it executes successfully. If it does then you execute your task and look into the logs for the actual error. You can view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@Kozel_GHR]

Great vid that can potentially save me considerable ammount of time weekly. The Schedulle works fine when I select "Run only when user is logged on" and if I have paths in quotes in tab "Actions" I have "Program/script" & "Add arguments (optional):". However if I select option "Run whether user is logged on or not" i fill in "Program/script" path to my python executable without quotes, I fill "Add arguments (optional):" with the python file name without quotes and I fill "Start in (optional):" with path to script without quotes. The script doesn't run in this case. Do you have any ideas why?

[@BiInsightsInc]

There might be errors in the background. You can check the logs to view the actual error. To view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@sportdatascience9014]

Is it necessary to activate the conda environment?

[@BiInsightsInc]

Only if you are working in a virtual environment then you would need to activate it. By default the base environment is already activated. Since we are working at the server level there is no need to activate a virtual environment. Here is a good read on virtual environment: www.freecodecamp.org/news/how-to-setup-virtual-environments-in-python/

[@juanpabloromero1447]

Thanks for the video! However, my script does not work since I need to set a conda environment to import certain libraries. I can do this in de cmd but not by just running the python.exe. Any ideas?

[@BiInsightsInc]

I think you need to install and set up the environment properly. I have covered the Anaconda distribution installation, link below. Feel free to check it out. kzbin.info/www/bejne/eGGqXmdqmdZ7iK8

[@cageman301]

I've had a similar problem before. Try setting up a batch script to activate a venv first before you run the program

[@victorinerichard1927]

Stupid question but : does it work when my computer is off ?? I am looking for this type of solution ...

[@BiInsightsInc]

This will not work if your machine is turned off. You can install it on a server that remains on to monitor and tigger the schedules.

[@SachinSingh-fs2xe]

My python.exe file is missing, what should i do

[@BiInsightsInc]

Install Python 🐍 and then add your Python location to the Path.

[@marcogelsomini7655]

number one!!

[@durrium]

Good instruction, however my program does not seem to work running. Testruns shows that "what program do you want to use to run this" then just gives error "0x2"

[@durrium]

Also says "cant find file"

[@durrium]

Not it says error message 0x1

[@BiInsightsInc]

Hi durrium, thanks for stopping by. You can check the logs to see what the actual error is. To view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@durrium]

@@BiInsightsInc Thank you for the detailed answer!

[@hopeh3503]

@BI Insights inc, thank you so much for this useful video. I have a question, hope you would answer me. I have a task scheduled, but I am unable find the log files which I am desperately looking for to know if the script has failed, reason for failure etc. Any idea?

[@BiInsightsInc]

Hi Hope, thanks for stopping by. To view the logs in Windows 10, start Event Viewer (eventvwr.msc) and navigate to "Applications and Services Logs" /Microsoft /Windows /TaskScheduler. The corresponding files are in C:\Windows\System32\winevt\Logs\Microsoft-Windows-TaskScheduler*.EVTX. You can also log errors to a log file in your code whenever there’s an exception. Here is a deep dive into how to troubleshoot windows Task Scheduler using windows server log files: dzone.com/articles/guide-troubleshoot-your-windows-task-scheduler-in

[@hopeh3503]

@@BiInsightsInc Thank you for responding quickly. I am still at my wits end as I couldn’t find what I am looking for. Please tell me where can I find the “Hello world” when I create a task to execute helloworld.py which contains one line of code print(“Hello world”). When I look at the event viewers, it says the task and action are completed successfully. There are no errors as such, but couldn’t find the output. Pls reply me.

[@BiInsightsInc]

@@hopeh3503 print statement text "Hello World" would be printed to a console window. If you are doing this for testing purpose then I wouldn't hide the console. Once your schedule runs it will open a console and you'd see your text printed there. I'd also add an input statement so the console window remains open otherwise, it would open and close in a flash. Hope this hleps. print("Hello World") input("Press enter to exit ;)")

[@hopeh3503]

@@BiInsightsInc Thank you, that’s helpful.

[@JosueQuintero-pj6tv]

THANKS!!🙏🙏🙏🙏🙏

[@benyoussefachraf919]

Thank you sir! But how can I get Windows Task Scheduler?

[@BiInsightsInc]

Task Scheduler is a base component of Microsoft Windows. If you are using Windows then simply serach for it and it should come up.

[@MrRaisin56]

Thanks! For anyone wondering this will not work with notebook files

[@BiInsightsInc]

For anyone interested in scheduling Jupyter Notebooks use the Jupyter Server Scheduler. I will be covering it in the future.

[@anurajms]

thank you

[@yashvarshney5577]

Nice, but upgrade your mic quality

[@pavanraj1618]

Sir I have try this but it's not working could you please help me with your mail id so that I can contact you and resolve the. It's very important please respond once you see the comments Please I'm requesting you

[@BiInsightsInc]

Hi Pavan, what’s the error you re receiving when you try to schedule a task? I’d advise try it with a simple script that prints hello world and see if it works for you.

[@pavanraj1618]

@@BiInsightsInc but I need to know whether my script will work or not, sir if possible could you please connect to me 5 mins via Google meet or something