[574] in Tooltime
FROZEN-->THAWED in kron job
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Thu Nov 20 14:54:42 1997
Date: Thu, 20 Nov 1997 14:54:30 -0500
To: wade@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Steve,
Could you change the kron job for changing the FROZEN logs as follows:
UPDATE mit_logs SET mit_status='THAWED'
WHERE mit_status='FROZEN' and
round(mit_frozen_ts,'DD') <= (select round(sysdate,'DD') from dual);
Note that there is only one statement now, not two, and there is no
reference to the mit_frozen_flag field. We will NOT be closing logs via the
kron job. Instead ,we will be using the "Close On Thaw" field only for
reference. We may get rid of it completely, eventually.
Cheers,
-Debi
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
