Set recurring notification for sms message
The two more popular SMS apps in the market - Handcent SMS and GoSMS have options that allow you to set reminder tones and LED flashing to alert a user to unseen messages. Lots of configurable options in both apps.