0361. 배치 잡랙별 시작시간 종료시간 run_time 데이터 추출

#!/bin/ksh #--------------------------- file   : BATCH.sh     --------------------------# stty cs8 -istrip echo echoe   find_jobrec(){  #echo "find_jobrec" $1  sqlplus -s tfoperc/tfoperc << EOF   set timing off   set head off   set linesize 130   set pagesize 50000   select distinct oppar_job_rec from oppar where oppar_job_name = '$1'; EOF }   rst_batch(){  echo "rst_batch start ----- " $1 " : " $2  sqlplus -s tfoperc/tfoperc << EOF   set timing off   set head off   set linesize 130   set pagesize 50000   select job_name, job_rec, start_name, run_time, result from endofday where run_time is not null and job_name = '$1' and job_rec='$2' and to_char(sys_creation_date,'yyyymmddhh24miss') between '200501010101' and '200602200101' order by start_name; EOF }     #if [ ! $# -eq 1 ] #then # echo [USAGE] ar.sh JOBNAME # echo please try again # exit 1 #fi   echo "-----------------------------------------------------------------------" echo "----- FIND BATCH JOB STATUS -------------------------------------------" echo "----- START TIME : `date`----------" echo "----- STOP this script : Type [exit] ----------------------------------" echo "-----------------------------------------------------------------------" echo   echo "root-7" echo while true do   echo "6" read JOBNAME?"INPUT SEARCH JOBNAME : ex)jobname : " #echo $JOBNAME   if [ $JOBNAME = "exit" ] then  echo "STOP this script"  exit 1 fi   nawk -F, 'BEGIN{ format="%-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n %-50s \n\n\n" print "--------- RESULT SEARCH BATCH JOB -----------------------------------------------" } /'$JOBNAME'/ { printf format, "구분 : "$1, "JOBNAME : "$2, "JOBREC : "$3, "업무명 : "$4, "업무상세명 : "$5, "장애등급 : "$6, "운영담당자 : "$7 , "운영팀연락처 : "$8, "담당자 : "$9, "연락처 : "$10, "JOB_ID : "$11, "작업주기 : "$12, "작업시기 : "$13, "TIME dependency : "$14, "선행디펜던시 : "$15, "후행디펜던시 : "$16, "job shell : "$17, "실행파일 : "$18}' BATCH.dat   echo "5" PS3="Select Number : "   select choice in Find_JobRec EXIT do  case $choice in    Find_JobRec)   echo "Find_JobName : ${JOBNAME}"   find_jobrec ${JOBNAME}   echo "4"   # start year status    read rst?"Continue BATCH result .... [yY/Nn] : "    if [ $rst = "Y"  -o $rst = "y" ]    then echo "3"     while true     do echo "2"      read rst_jobname?"Input JobName : "      read rst_jobrec?"Input JobRec : "      rst_batch ${rst_jobname} ${rst_jobrec}           read con?"Continue .... [yY/Nn] : "      if [ $con = "N" -o $con = "n" ]      then echo "1"       echo "STOP this script"       break             fi     done    fi   break;;    EXIT)   echo "STOP this script"   exit 1   break;;    *) echo "Reply Try again!!"  esac done   done