Sending automated reminder Email from Sql Server

Question

Hi All,
       am working on Travel Domain IT Company,in that i work on Flight Module. I save date of travel,flight departure time,passenger information like emailID , mobile no etc in database. My task now is to send a reminder Email and SMS to passenger 24 hrs before his departure time.How i can do this .I am using Asp.net,c# and Sql server 2008.

Thanks in Advance
Vishwas