event fired from watching sql

[mgriffith]

i need to figure out a way to do something. basically i need to re-email people if a node in the database hasn't been fullfilled through another application in a given number of days. i have a view from sql to show me which ones are in violation at any given time, but what i need to do is write some application that will run once a day automatically at a given time. is there some way to do this...maybe just an infinite loop, but i don't want to hit the database many times a second...just once a day. is there some type of timer built into c# that could do this?

thanks.

 

[mgriffith]

nevermind...i got it...i'm just going to use c#'s built in timer control and set it to 24 hours, then do what i want when the event is fired

 

[chiph]

That's what I was going to suggest anyway.
<grin>

You might want to write it as a Windows Service, so that it runs automatically when the OS starts up.

Chip H.