Question
What's the easiest way to setup automatic nightly SQL script executions?
Hi there,
I was wondering how I could most easily setup nightly SQL script executions using the RDBMS here. I’m hoping to build a MySQL or Microsoft SQL Server database (as I learned how to use these in college) here for a personal learning project.
Every night, I’d like to run some CRUD queries to update my tables. Can anyone please point me in the right direction?
Thank you!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @nirox,
My suggestion would be for you to use cron jobs. The cron jobs should be executed at night whenever you want and they should be scripts. In these scripts, you can specify what database queries to be done. I think that’s the best option and one that is largely used in most setups!
Regards, KFSys
Sorry, one more question. As I’m hoping to use the free tier for now, is it correct to say that I would be using Kubernetes to host my MySQL database?
I have about 5 relational tables with a few dozen records in each.