I need a simple example using the mariadb even scheduler function to act like a cron job.
-Create a table with columns including seconds, minutes, hours, daily, weekly, monthly.
-Create a bash script that constantly checks the db to run something.
-In the example
a: run 'ls -la' every 20 seconds.
b: run 'date' every 60 seconds.
c: run some other command every 50 seconds.
d: run one more command every week.
Basically, show how this can be used in some of the examples I see on the Internet.
Each command must run outside of the script and return a 1 or a 0 depending, completed or not.
You must do this on your own PC and send me the code so I can test, give feedback until we get to a point of an example, then we are done.