Création tables jobs
<SCHED_GROUP <ON_GROUP CODE="OK" > <DOFORCEJOB ODATE="ODAT" TABLE_NAME="C1CSP018JO"/> </ON_GROUP> <INCOND AND_OR="AND" NAME="PE-CSDG47AN-END" ODATE="ODAT" /> <OUTCOND NAME="PE-CSDG43AN-END" ODATE="ODAT" SIGN="ADD"/> <ON_GROUP CODE="OK" > <DOCOND NAME="PE" ODATE="ODAT" SIGN="ADD"/> </ON_GROUP> <JOB> <CONTROL NAME="CTRL_GIPMDS_PROD" TYPE="E"/> <INCOND AND_OR="AND" NAME="CBCFT-OK-WCBCFT05JO-NETOPS05" ODATE="ODAT" /> <QUANTITATIVE NAME="MAX_CB" QUANT="1" /> <?xml version='1.0' encoding='ISO-8859-1' ?> <!DOCTYPE DEFTABLE SYSTEM "deftable.dtd"> <DEFTABLE > <SCHED_GROUP ADJUST_COND="0" APPLICATION="CSCS-N00NR" AUTHOR="emuser" CONFIRM="0" CREATION_DATE="20151012" CREATION_TIME="135448" CREATION_USER="emuser" CRITICAL="0" DATACENTER="AGORA_R92_AIX" DESCRIPTION="GIPR Notifications EVA" GROUP="CSCS4VJO-N00NR" JOBNAME="CSCS4VJO-N00NR" LAST_UPLOAD="Mon Oct 12 12:12:16 NFT 2015" MAXWAIT="0" MEMNAME="CSCS4VJO-N00NR" OWNER="agora" PRIORITY="AA" TABLE_NAME="CSCS4VJO-N00NR" TABLE_USERDAILY="CSCS-N00NR" CONFIRM="1" TIMEFROM="1600" USED_BY_CODE="0"> <TAG APR="1" AUG="1" DAYS_AND_OR="OR" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="05" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="CSCS4VJO" WEEKDAYS="0,1,2,3,4,5,6" ==> 0-Samedi 1-dimanche 2-lundi 3-mardi 4-mercredi 5-jeudi 6-vendredi WEEKDAYS="2,3,4,5,6,0" Lundi-> Samedi WEEKSCAL="MSAALL"/> <TAG APR="1" AUG="1" DAYS_AND_OR="OR" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="05" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="TLJT" WEEKDAYS="2,3,4,5,6,0" /> <TAG APR="1" AUG="1" DAYS="3" ==========> le 3 de chaque mois DAYSCAL="ALLD" DAYS_AND_OR="OR" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="00" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="CSCS4UME" WEEKSCAL="MSAALL"> <TAG_NAMES TAG_NAME="CSAG180999-N00NR"/> #+++++++++++++++++ si DAYS et on a tous les jours du mois s/WEEKSCAL/DAYSCAL/ ++++++++++++++++++++++++++++++++++++ #==================================================================================== ======================== le 14 de chaque trimestre jour ouvré sinon report voir CSCS91DE-N00NR #==================================================================================== <TAG APR="1" AUG="0" DAYS=">14" DAYSCAL="MSAWORK" DAYS_AND_OR="OR" DEC="0" FEB="0" JAN="1" JUL="1" JUN="0" MAR="0" MAXWAIT="05" MAY="0" NOV="0" OCT="1" RETRO="0" SEP="0" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="CSCS910000" /> #==================================================================================== #---------------------------- dernier mercredi du mois #==================================================================================== Trois tags pour les mois de 31j puis 30j et fevrier <TAG CONFCAL="ALLD" DAYS="-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14,-15,-16,-17,-18,-19,-20,-21,-22,-23,-24" DAYSCAL="ALLD" DAYS_AND_OR="AND" JAN="1" FEB="0" MAR="1" APR="0" MAY="1" JUN="0" JUL="1" AUG="1" SEP="0" OCT="1" NOV="0" DEC="1" RETRO="0" MAXWAIT="00" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="LASTMER_31" WEEKDAYS="-1,-2,-3,-5,-6,-0" WEEKSCAL="ALLD"/> <TAG CONFCAL="ALLD" DAYS="-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14,-15,-16,-17,-18,-19,-20,-21,-22,-23" DAYSCAL="ALLD" DAYS_AND_OR="AND" JAN="0" FEB="0" MAR="0" APR="1" MAY="0" JUN="1" JUL="0" AUG="0" SEP="1" OCT="0" NOV="1" DEC="0" RETRO="0" MAXWAIT="00" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="LASTMER_30" WEEKDAYS="-1,-2,-3,-5,-6,-0" WEEKSCAL="ALLD"/> <TAG CONFCAL="ALLD" DAYS="-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14,-15,-16,-17,-18,-19,-20,-21" DAYSCAL="ALLD" DAYS_AND_OR="AND" JAN="0" FEB="1" MAR="0" APR="0" MAY="0" JUN="0" JUL="0" AUG="0" SEP="0" OCT="0" NOV="0" DEC="0" RETRO="0" MAXWAIT="00" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="LASTMER_28" WEEKDAYS="-1,-2,-3,-5,-6,-0" WEEKSCAL="ALLD"/> Sur Job TAG_RELATIONSHIP="OR" <TAG_NAMES TAG_NAME="LASTMER_31"/> <TAG_NAMES TAG_NAME="LASTMER_30"/> <TAG_NAMES TAG_NAME="LASTMER_28"/> Sur job pour fevrier (mais fonctionne pas) DAYS="-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14,-15,-16,-17,-18,-19,-20,-21,-22" DAYSCAL="ALLD" DAYS_AND_OR="AND" TAG_RELATIONSHIP="OR" WEEKDAYS="-1,-2,-3,-5,-6,-0" WEEKSCAL="ALLD" #------------------------------------------------------------------------------- <TAG APR="1" AUG="1" CONFCAL="MSAWORK" DAYS_AND_OR="AND" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="00" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="NEXTDAY" SHIFTNUM="+00" TAG_NAME="CSCS4PME" WEEKDAYS="4" ====> Mercredi /> Sans saut jour suivant SHIFT="IGNOREJOB" SHIFTNUM="+00" ############################################# ## ## regle de planification pour le 30 de chaque mois ## ############################################# <TAG APR="1" AUG="1" DAYS="-1,<1,-29,-31" DAYSCAL="MSAALL" DAYS_AND_OR="OR" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="05" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="PREVDAY" SHIFTNUM="+00" TAG_NAME="CSAL43ME-N00NR" /> Dans JOB pas de DAYS= ne pas oublier les <JOB ... <TAG_NAMES TAG_NAME=" ctmrpln Y Y CSAL43ME-N00NR CSAL43ME-N00NR 2016 Year = 2016 1 2 3 1234567890123456789012345678901 JAN:.............................*. FEB:...........................*. MAR:.............................*. APR:.............................* MAY:.............................*. JUN:.............................* JUL:.............................*. AUG:.............................*. SEP:.............................* OCT:.............................*. NOV:.............................* DEC:.............................*. *** USER_DAILY : CSAL-N00NR ########################################################## ####################### Le 30 pour tous les mois sauf fevrier <TAG APR="1" AUG="1" DAYS="30" DAYSCAL="MSAALL" DAYS_AND_OR="OR" DEC="1" FEB="0" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="05" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="PREVDAY" SHIFTNUM="+00" TAG_NAME="CSAL43ME-N00NR" /> <TAG APR="0" AUG="0" DAYS="27" DAYSCAL="MSAALL" DAYS_AND_OR="AND" DEC="0" FEB="1" JAN="0" JUL="0" JUN="0" MAR="0" MAXWAIT="00" MAY="0" NOV="0" OCT="0" RETRO="0" SEP="0" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="CSAL43ME-FEV" /> ############################################################################## ############################################################################## ####################### Avant dernier jour du mois <TAG APR="1" AUG="1" DAYS="-1,<1,-29,-31" DAYSCAL="MSAALL" DAYS_AND_OR="OR" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="00" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="TEST-30" /> Year = 2016 1 2 3 1234567890123456789012345678901 JAN:.............................*. FEB:...........................*. MAR:.............................*. APR:.............................* MAY:.............................*. JUN:.............................* JUL:.............................*. AUG:.............................*. SEP:.............................* OCT:.............................*. NOV:.............................* DEC:.............................*. *** USER_DAILY : NONE ####################### tous sauf 29 et 31 <TAG APR="1" AUG="1" DAYS="-29,-31" DAYSCAL="MSAALL" DAYS_AND_OR="OR" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAXWAIT="00" MAY="1" NOV="1" OCT="1" RETRO="0" SEP="1" SHIFT="IGNOREJOB" SHIFTNUM="+00" TAG_NAME="TEST-30" /> ctmrpln Y Y CSAL43ME-N00NR CSAL43ME-N00NR 2016 Year = 2016 1 2 3 1234567890123456789012345678901 JAN:****************************.*. FEB:****************************. MAR:****************************.*. APR:****************************.* MAY:****************************.*. JUN:****************************.* JUL:****************************.*. AUG:****************************.*. SEP:****************************.* OCT:****************************.*. NOV:****************************.* DEC:****************************.*. *** USER_DAILY : CSAL-N00NR
Previous page: Force stop DB EM
Page suivante : $U Automic