I have been asked a question in system design interview to build a system where a message needs to be be sent at the mentioned time inside the message should not be and mentioned to be exact on the seconds mentioned in the timestamp

I can think of making a Scheduled job for this but running scheduled job every second would not be the solution . All the records are in data base

Eg Record A has timestamp 12/10/2024T22:10:34 should be sent at this specific time

I think the approach of scheduling will not work so any approach for above mentioned problem