So I create a job with this:

select *

from Asgnmnt

where TimeRevc < dateadd( hour, -24, getdate())

and TimeAcknow = ''

How would I get it to send an email to the Assignee of...

Thank you!

I think that for this task, running a scheduled job would work best after looking at your replies. This way it is done everyday and it doesn't matter...

Thank you Steve,

The first thing that I want to happen is if the column TimeRevc is older than 24 hours and the column TimeAcknow is blank then I want a...