If I understood your question correctly, you could use SQL Agent to regularly check the data in the db. If it's time to send a message (based on the info in the db) you could execute for example a shell script, send an email etc.
For more info, have a look at:
Creating Jobs[
^]