📄 check_db_access.sh.shtml
字号:
<HTML><HEAD><TITLE>PRS Technologies, Inc. - script: check_db_access.sh</TITLE><META NAME="Description" content="PRS Technologies Inc. - Check and log access to the database"><STYLE TYPE="text/css"><!--A.CLASS1 {background-color: #000066; color: white; letter-spacing: 0.2ex; font-size: 14pt; text-decoration: none;}A:hover.CLASS1 { background-color: #ffffcc; color: black;}--></STYLE><SCRIPT>defaultStatus = "PRS Technologies Inc. - script: check_db_access.sh";</SCRIPT></HEAD></CENTER><CENTER><TABLE border=0 cellspacing=0 cellpadding=0 width=90%><TR><TD> <CENTER> <IMG SRC="../gif/prs_tech_top_of_page1.gif" border=0 align=center alt="PRS Technologies Home Page"> </CENTER></TD></TR><TR><TD> <CENTER> <TABLE border=2 cellspacing=0 cellpadding=0> <TR> <td><A HREF="../index.shtml" CLASS=CLASS1> Home </A> <td><A HREF="../resume.shtml" CLASS=CLASS1> Associates </A> <td><A HREF="../references.shtml" CLASS=CLASS1> References </A> <td><A HREF="../downloads.shtml" CLASS=CLASS1> Downloads </A> <td><A HREF="../elite1.shtml" CLASS=CLASS1> Elite </A> <td><A HREF="../links.shtml" CLASS=CLASS1> Links </A> <td><A HREF="../contacts.shtml" CLASS=CLASS1> Contact Us </A> </TR> </TABLE> </CENTER></TD></TR></TABLE></CENTER><BR><CENTER><TABLE border=0 cellpadding=4 bgcolor=e7e7ce><tr><td><font color=#000066 size=+2><B>check_db_access.sh</B></font></td></tr></table></CENTER><XMP>#################################################################################!/usr/bin/ksh################################################################################## Module: check_db_access.sh# Author: Peter R. Schmidt# Description: Check and log access to the database# Make 4 attempts per minute - each 15 seconds apart## Arguments## Argment: -v Interactive - display to screen - no e-mail## Change Log## Date Name Description.................# 09/03/02 Peter R. Schmidt Start Program#################################################################################FG=falsefor ARGdo case "$ARG" in -v) FG=true;; esacdone# Set the environment. /elite/custom/run.eliteLOGDIR=/elite/work/logsLOGFILE=$LOGDIR/check_db_access.logTMPFILE=/tmp/check_db_access.logrm -f $TMPFILEif [ ! -d $LOGDIR ]; then echo "Error: check_db_access.sh: Directory: $LOGDIR does not exist!" exit 1fi#-------------------------------------------------------------------------------for TRY in 1 2 3 4 # Make 4 attempts per minute - seach 15 seconds apartdoUDATE=`date +%m/%d/%y`UTIME=`date +%H:%M:%S`# Try to access the database - log failuresdbaccess son_db <<-EOF 2>&1 > $TMPFILEEOFif [ $? != 0 ]; then echo "$UDATE $UTIME Fail" >> $LOGFILE cat $TMPFILE >> $LOGFILE if [ $FG = true ]; then tail -1 $LOGFILE cat $TMPFILE fielse echo "$UDATE $UTIME OK" >> $LOGFILEfiif [ $FG = true ]; then breakelse sleep 15 # Make 4 attempts per minute - seach 15 seconds apartfidonerm -f $TMPFILE################################################################################</XMP><CENTER><TABLE border=2 cellspacing=0 cellpadding=0><TR><td><A HREF="../index.shtml" CLASS=CLASS1> Home </A><td><A HREF="../resume.shtml" CLASS=CLASS1> Associates </A><td><A HREF="../references.shtml" CLASS=CLASS1> References </A><td><A HREF="../downloads.shtml" CLASS=CLASS1> Downloads </A><td><A HREF="../elite1.shtml" CLASS=CLASS1> Elite </A><td><A HREF="../links.shtml" CLASS=CLASS1> Links </A><td><A HREF="../contacts.shtml" CLASS=CLASS1> Contact Us </A></TR></TABLE></CENTER></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -