... I am trying to run an update on a field that will change a record status to 'live' if a record close date is in five days time.
I thought of a trigger but there is nothing to trigger it to run except changing of sysdate. the only other way i could think of doing it was a scheduled DTS package running at 00:01 each day.
Can anybody provide any other suggestions or solutions.
Sorry for posting here but was unsure as to best place for this messgae.
Cheers