I use Klaxon. There are some options to set for SMS texts received. I use it to alert me every 2 minutes for missed text messages. I am freqently on call at all hours, so I need an annoying attention-getting alert. Klaxon works and has never failed me - even after upgrade to Android 2.3.3
I have a Motorola Droid 2 Global (Verizon)