0256 [UNIX 013. sh] 쉘 배치로그 조회 스크립트
0256 [UNIX 013. sh] 쉘 배치로그 조회 스크립트 |
|
#!/bin/ksh TODAY=`date +'%Y%m%d'`09 TODAY2=`date +'%Y%m%d'` YESTERDAY=`expr $TODAY2 - 1`21 FILE_NAME=`date +'batch_%Y%m%d.log'` FILE_DIR="/users/oper/kim/batch_check/" echo $TODAY $YESTERDAY $FILE_NAME $FILE_DIR
sqlplus -s tfoperc/tfoperc <<EOF set timing on set head off spool $FILE_DIR$FILE_NAME
#--TOTAL select 'TOTAL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY; select 'TOTAL SUCCESS COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and result in ('success','successfuly'); select 'TOTAL FAIL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and result in ('failure','with failure'); #--AR select 'AR TOTAL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'AR%'; select 'AR SUCCESS COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'AR%' and result in ('success','successfuly'); select 'AR FAIL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'AR%' and result in ('failure','with failure'); #--CSM select 'CSM TOTAL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'CS%'; select 'CSM SUCCESS COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'CS%' and result in ('success','successfuly'); select 'CSM FAIL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'CS%' and result in ('failure','with failure'); #--RDS select 'RDS TOTAL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'RDS%'; select 'RDS SUCCESS COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'RDS%' and result in ('success','successfuly'); select 'RDS FAIL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'RDS%' and result in ('failure','with failure'); #--BL select 'BL TOTAL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'BL%'; select 'BL SUCCESS COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'BL%' and result in ('success','successfuly'); select 'BL FAIL COUNT = '||count(*) from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and JOB_NAME like 'BL%' and result in ('failure','with failure'); #--ETC #
#--FAIL JOB SELECT select job_name, job_rec, to_char(sys_creation_date,'YYYY-MM-DD HH24:MI:SS'), result from endofday where to_char(SYS_CREATION_DATE, 'yyyymmddhh24') between $YESTERDAY and $TODAY and result in ('failure','with failure');
spool off EOF |
'IT' 카테고리의 다른 글
| 0258 [UNIX 012.] split 파일 자르기 (0) | 2016.01.28 |
|---|---|
| 0257 [UNIX 13.09.] tee 를 이용하여 출력을 여러곳으로 보내기 (0) | 2016.01.28 |
| 0255 sh 쉘 디스크 스페이스 체크 스크립트 (0) | 2016.01.28 |
| 0254 [UNIX 015.] sh 쉘 빌드로그 체크 스크립트 (0) | 2016.01.28 |
| 0253 [UNIX 22.02.] 파일과 디렉토리 퍼미션에 대한 안내 (0) | 2016.01.28 |
