How to create a database to run commands on a schedule?

Question

MySQL

The question is how to implement a database with a launch schedule, one object can have as many launches per day according to the schedule, the schedule is tied only to the clock, let's say the script starts looking at the time, for example, 9:00 climbs into the database and sees what is needed now run according to the schedule, namely which objects have the time 9:00, takes them and launches them. Tell me how to build a schedule database architecture and preferably a compact structure

Answer 1

CREATE TABLE schedule ( schedule_id INT PRIMARY KEY,
                        start_time TIME,
                        task_id INT );

In one record - one time and one task. No CSV sets.
If the tasks have a separate table - then, accordingly, FOREIGN KEY in it.