Having a SQL trigger sending email when data is changed is not a good idea.
However, you may still want to get email ASAP, faster than periodic job...
You can follow the previous advise to create a trigger which audit the changes into another table. Then design a service which pools the table and sends emails...
Beeing in SQL2008, instead of triggers you may be interesting to try in-built CDC (change tracking)