Re: Automate an update

[AK]

This may be complex but I think can work , create a payload in advanced queue with delay=8hrs ( or whatever ). run a job(immediately..no future timing) which listens to this advaced queue . As soon as job gets the event in queue (after 8hrs) it will update the column based on logic ( if time = ...blah blah ) and at the end it will insert another item in queue with delay=8hrs . So in 24hrs job will get  3 payloads and check the timing at that time .. . This job will be running in an infinite loop . You can create some other procedure to stop it , by sending some particuler item in queue .   As usual there might be more methods you will be getting in few minutes :)   -Ak ----- Original Message ----- From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 02, 2003 2:40 AM Subject: Automate an update Hi all,   I need help in order to create a following "mechanism".   I have a table where is a column called window_open and it has two values 'Y' and 'N'   Now I need to automate the update a single row based on following rules:   If time is between 08:00-16:00 the value on that window_open column should be 'Y' during other period the value should be 'N'. How can I do this and automate the task...   Thanks in advance,   Joshua G� f�re i k�n och f� din sajt v�rderad p� nolltid med Yahoo! Express