[517] in Tooltime
Re: kron job problem
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Fri Nov 14 13:43:54 1997
In-Reply-To: <v03020904b0922343bd75@[18.81.0.229]>
Date: Fri, 14 Nov 1997 13:48:11 -0500
To: Debi Fuchs <debi@MIT.EDU>
From: Steven Wade Neiterman <wade@MIT.EDU>
Cc: tooltime@MIT.EDU
Done, this seemed to work.
I probably don't understand why the mit_frozen_flag would be NULL and not
have either a Yes or a No value.
Here is another issue. When closing a log, we should update the closed
date and maybe by whom.
The same should probaby be true of the change to pending, maybe we should
update the modified by field.
..Steve
At 10:59 AM -0500 11/14/97, Debi Fuchs wrote:
>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
