Ryan,
I am looking to using the notification_date field in notifications table to schedule a notification for a certain time.
I am looking into this because News allows you to publish an item in the future and there isn't a simple way to trigger the notifications after publishing.
A similar feature would work for reminders.