[575] in Tooltime
Re: FROZEN-->THAWED in kron job
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Thu Nov 20 15:51:53 1997
In-Reply-To: <v03020900b09a28ba747e@[18.81.0.229]>
Date: Thu, 20 Nov 1997 15:55:57 -0500
To: Debi Fuchs <debi@MIT.EDU>
From: Steven Wade Neiterman <wade@MIT.EDU>
Cc: tooltime@MIT.EDU
Done, it will run tonight. You may want to test this tomorrow.
..Steve
At 2:54 PM -0500 11/20/97, Debi Fuchs wrote:
>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
