> I think its just too insane to query the db X mins just to check if there are any scheduled emails to send out

That's exactly what I do, took maybe 10 minutes to put together - runs once a week, and calculates a bunch of statistics that get emailed out once a week.