Your db needs to store what triggered the SMS the destination the sending and time stamp for both initial request and acknowledgement from whatever SMS service you use because that stuff fails and they will always delay tickets asking for this before they look further

thanks!