Hi there,
Any results here on the best implementation, possibly using a local plugin for the cron that will run the SQL query and possibly use the PHPMailer class (although Moodle extends it on its own) .
Would love to hear a follow-up on this if any solutions have been drawn up.
Cheers.