How to design table to send email reminders for Appointments?

[Sam]

Hi

I am looking for a jump start on how I should go about designing this
table.
I need to have an App like a meeting reminder that needs to send an
email
on the day of the Meeting but also if some meeting were missed if PC
turned off

The table I have contains besides meeting info these fields

Data/Time of Meeting Status of Reminder
mmddyyyy:time Sent reminder Yes/No


The problem I am having is what if the PC is off for an extended length
of time
Should I query the whole db for date before current date or somehow
store the last time
that query was run ????

Anyone have idea how this is typically setup????

Thanks