ЕНЯ,
IF EXISTS (SELECT * FROM MyTable WHERE DateCol >= DATEADD(day,-10, getdate()))
BEGIN
EXEC msdb.dbo.sp_send_dbmail
@to = 'whoever@yourcompany.com',
@profile_name = 'default',
@subject = 'Someone was speeding',
@body = 'Yep, Check the table.';
END