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