You can use system stored procedure xp_sendmail to send mail.

>I have a SP that checks datetime stamps on 12 tables. I am scheduling the SP to run every half hour. If the most recent datetime stamp is more than 30 minutes old I would like the SP to trigger an alert that would email me. How do I write a Stored Procedure that can do this?