there's an app called smssend for sending SMSes via command line.
you can use it with alarmd or use a script on it to achieve what you want...

kh