Little help with creating a timed event

See more:

SQL

Here is what I would like to happen

CREATE TRIGGER EmployeeClockin ON Timeclock

FOR Insert

AS

Catch inserted time and have a timer running against it.

If timer >6 hours 

Send email

I have most of the code I need all ready written, I just have no idea if what I want to happen is possible in SQL.

I got the email to work, etc, I just need something that will fire this off after a certain amount of time has passed.

I usually write in VB and im still a little green when it comes to SQL so any help would be great :)