hi,
i needed some help with writing and scheduling a stored procedure, our
dba is out and we need this done :) it's fairy simple, we have an
application that users fill out, once filled and user is emailed asking
to respond within 7 days, if no response is received we set a flag in a
table. we wanted to just write a procedure that would run every night
and simply check if the date (data_entry field) was a week back, if so
then we would like it to set a flag to 1 (no_res field). that's it,
just need some help with it, where to start, as we're not the ones who
usually do this.
Thanks.
Received on Thu Nov 17 2005 - 12:55:47 CST
