delete ajf
Delete Jobs Group dans AJF en masse
- Script ctmdelajf permettant de lister et composer les requetes sql pour mettre en Deleted Jobs et Group dans AJF
#!/bin/sh # pour generer # update CMR_AJF set AJFSONSTR='NNNNNNNNNNNNNN', HOLDFLAG='D', STATE = '8', OSCOMPSTAT=0 , STATUS='Y' where ORDERNO = 314396; # ##set -vx set -a . ~/.profile # Help="ex. :\n ctmdelajf Hist ou Nat cde ex cde : 'ctmpsm -listgroup C1_CSP0 C1CSP017JO |grep 201409'" test $# -lt 2 && echo ${Help} && exit cde=$2 case "$1" in [h,H]ist) datacenter=n-t-92e ctmuser=ctmuser passwd=password ;; [n,N]at) datacenter=n-t-92a ctmuser=ctmuser passwd=password ;; *) echo ${Help};exit ;; esac Fictemp=/cygdrive/c/temp/temp_$$ cat << @EOFFF > ${Fictemp} ssh ${datacenter}@druon sqlplus -S << @EOFF ${ctmuser}/${passwd} set echo off head off pagesize 0 feedback off linesize 300 ; @EOFFF for ord in $(eval ${cde}|awk '/^0/,/GRP/{ print $1 }');do eval $(base36 $ord |sed 's/ //g');echo "update CMR_AJF set AJFSONSTR='NNNNNNNNNNNNNN', HOLDFLAG='D', STATE = '8', OSCOMPSTAT=0 , STATUS='Y' where ORDERNO = ${result};";done >> ${Fictemp} cat << @EOFFF >> ${Fictemp} quit @EOFF @EOFFF echo -e "\n========== cde dans ${Fictemp} =====\n" cat ${Fictemp} exit
Previous page: Cas Unknown
Page suivante : NewYear Calendars