linux中脚本的日志,shell 脚本运行日志通用模块

function init_log()

{

sqlplus -S [email protected] <

insert into program_log values($id,$day,'$1', sysdate,null,'S',null);

commit

exit

EOF

}

function modify_status(){

sqlplus -S [email protected] <

update program_log set program_status='$1',end_date=sysdate where id=$id;

commit

exit

EOF

}

function exception_write(){

if [ $? -ne 0 ]

then

modify_status $status2

exit 1

fi

}

function finish_write(){

if [ $? -eq 0 ]

then

modify_status $status1

#modify_status $1 $2 $3

else

# modify_status $1 $2 $3

modify_status $status2

exit 1

fi

}

status1=C

status2=F

day=`date "+%Y%m%d"`

id=`sqlplus -S [email protected] <

set heading off

select program_log_seq.nextval from dual;

commit

exit

EOF`#!/bin/sh

. ~/.bash_profile

source program_log_new.sh //公用脚本

init_log sh_xx //初始化日志函数调用,传入程序名

shell命令xxx 2>${logdir}/xx_$time.log

exception_write //发生异常，调用异常，程序退出

shell命令xxx 2>${logdir}/xx_$time.log

exception_write //发生异常，调用异常，程序退出

....

shell命令xxx 2>${logdir}/xx_$time.log

finish_write //发生异常，调用异常，程序退出