phil2phil wrote:
> 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.
>
www.psoug.org
click on Morgan's Library
click on DBMS_JOB
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Nov 17 2005 - 16:59:13 CST
