Shapeshifter wrote a gui for alarmd configuration (alarmed) and alarmd can schedule arbitrary commands e.g. Smssend.

Also, since alarmed is python, modifying it to do exacly what you're looking for instead.of general purpose might be practical.

edit because remembering is hard. Let's go shopping.