Changeset 13094 for trunk/DataCheck/Monitoring/CheckStatus.sh

Timestamp:

03/14/12 09:03:44 (13 years ago)

Author:

Daniela Dorner

Message:

improved logging

File:

• trunk/DataCheck/Monitoring/CheckStatus.sh (modified) (3 diffs)

trunk/DataCheck/Monitoring/CheckStatus.sh

@@ -31 +31 @@
    
    # check table for failed jobs
+   printprocesslog "INFO checking "$step" for failed jobs."
    where=" WHERE NOT ISNULL(fReturnCode) "
    where=$where" AND fStopTime > ADDDATE(NOW(), INTERVAL -25 HOUR)"              
    query="SELECT Count(*) FROM "$step"Status "$where
    num=`sendquery`
-   printprocesslog "WARN found in "$step" "$num" rows with errors."
    if [ $num -gt 0 ]
    then
+      printprocesslog "WARN found in "$step" "$num" rows with errors."
       sel=$selstart", '(', fReturnCode, ')')"
       query="SELECT "$sel" FROM "$step"Status "$where
@@ -47 +48 @@
    #   i.e. jobs which are running > 2 hours
    # check the last 27 hours
+   printprocesslog "INFO checking "$step" for crashed jobs."
    where=" WHERE NOT ISNULL(fStartTime) AND ISNULL(fStopTime) "
    where=$where" AND fStartTime < ADDDATE(NOW(), INTERVAL -2 HOUR)"
@@ -52 +54 @@
    query="SELECT Count(*) FROM "$step"Status "$where
    num=`sendquery`
-   printprocesslog "WARN found in "$step" "$num" crashed jobs."
    if [ $num -gt 0 ]
    then
+      printprocesslog "WARN found in "$step" "$num" crashed jobs."
       sel=$selstart", '(', fStartTime, ')')"
       query="SELECT "$sel" FROM "$step"Status "$where