What is the best way to implement sending emails with a delay of a couple of hours?

Question

Yii

Hello!
At me now a task to send letters to the client, with a delay in 1-2 hours. Those. the client left a request on the site, and a letter about this request should come to the operator after a fixed period of time. What is better to use for this? Maybe a queue server?

Answer 1

We enter it into the database after the fact, write the time in a timestamp, write the status sent \ not sent, go through the records by cron comparing the time from the request and from the current one, check the sending status, if everything goes according to the conditions - change the status of the record, send it to the operator.

Answer 2

Cron