Création tables jobs

  • Paramètres pour créer des schedtab and 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