July 5, 2002 at 4:28 am
... 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
Cheers
July 5, 2002 at 5:14 am
DTS would work, though maybe more than you need. Sounds like a simple update statement running in a TSQL job step should do the trick.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply