asp.net - Automatic Mailing based on server datetime -

asp.net - Automatic Mailing based on server datetime -

i working in asp.net mvc, have scenario follows.

"employee have specific end time finish task, 1 time time completed, mail service has sent automatically team lead notify."

in way have check server datetime , specified end datetime constantly,my frnd suggested me check database datetime endtime every 30 secs creating console scheduler watch time, have alternative without checking database frequently?

i suggest windows service check timings.

do have alternative without checking database frequently

you implement kind of caching mechanism - maintain tasks in memory , check against server time - if tasks updated cache become outdated or need way synch cache database.

so usethe approach check every x seconds (30 seconds seems little, how accurate want notifications be?? perhaps 1 time every 5 minutes plenty depending on requirements).

asp.net asp.net-mvc-3 asp.net-mvc-4 scheduler