Try the Easy Reminder app. You can set the alert frequency for both SMS and MMS so that if you miss the first alert, it will alert you again in 5 minutes or whatever you set it to. You can also change the time when it is active so it is not sending alerts in the middle of the night!