[512] in Tooltime
kron job problem
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Fri Nov 14 10:59:29 1997
Date: Fri, 14 Nov 1997 10:59:39 -0500
To: wade@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Hi Steve,
I'm afraid the code I sent you for the kron job wasn't complete. As is, it
is not touching any logs which do not have the frozen flag filled in, i.e.
where mit_frozen_flag is NULL. Instead of:
UPDATE mit_logs SET mit_status='PENDING'
WHERE mit_status='FROZEN' and upper(mit_frozen_flag)<>'YES' and
round(mit_frozen_ts,'DD') <= (select round(sysdate,'DD') from dual);
We should use:
UPDATE mit_logs SET mit_status='PENDING'
WHERE mit_status='FROZEN' and
(mit_frozen_flag IS NULL or upper(mit_frozen_flag)<>'YES') and
round(mit_frozen_ts,'DD') <= (select round(sysdate,'DD') from dual);
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
