Definition of table: AJPP - jobplan process (archived)

generated: 09.12.2016 10:26:50
by UC2010.accdb

AE Database 12.0 (Step 013)



Name Type Len Attributes Description
AJPP_AH_Idnr Long Integer 4 UC: Null=False reference to the archive header (AH)
AJPP_Lnr Integer 2 UC: Null=False ascending number of the jobplan process
AJPP_Status Long Integer 4 UC: Null=True state of the process line of the jobplan (blocking ...)
AJPP_JobStatus Long Integer 4 UC: Null=True state of the process line from the job execution (ok,ended,abended)
AJPP_Substatus Text 1 UC: Null=True sub state (H, A) if precondition (WHEN) is not true
AJPP_OType Text 8 UC: Null=True 1=START, 2=JOB, 3=JP, 4=GROUP, 5=Script, 6=FT, 7=Event, 8=Call Operator, 9=END
AJPP_Object Text 200 UC: Null=True object name
AJPP_ErlstStTime Text 10 UC: Null=True Earliest start time
AJPP_LtstStTime Text 10 UC: Null=True Latest start time
AJPP_LtstEndTime Text 10 UC: Null=True Latest end time
AJPP_WElse Text 1 UC: Null=True WHEN ... ELSE S=SKIP, H=HALT, A=ABEND, X=Block + Abort Signal
AJPP_WCType Text 1 UC: Null=True WHEN condition type: space = AND, O=OR
AJPP_CCType Text 1 UC: Null=True CALE condition type: 2=CALE EQ, 3=CALE NE, 1 =CALE AND, 4=CALE Ext.
AJPP_StartTime Date/Time 8 UC: Null=True start time
AJPP_EndTime Date/Time 8 UC: Null=True end time
AJPP_PreCnt Integer 2 UC: Null=True number of internal predexessors (AJPPA) of this AJPP
AJPP_Row Integer 2 UC: Null=True y-coordinate for jobplan graphic
AJPP_Col Integer 2 UC: Null=True x-coordinate for jobplan graphic
AJPP_MsgNr Long Integer 4 UC: Null=True return code
AJPP_MsgInsert Text 50 UC: Null=True L=1024 message insert to the message number
AJPP_RetCode Long Integer 4 UC: Null=True return code
AJPP_Restart Byte 1 UC: Null=True was this a restarted activation?
AJPP_RefNr Long Integer 4 UC: Null=True reference job number
AJPP_WhenExecute Text 200 UC: Null=True Call-Operator for HALT
AJPP_Active Byte 1 UC: Null=True bitmask: bit 1= active/inactiv, bit 2: hold/normal
AJPP_RWhen Text 30 UC: Null=True Result: standard result
AJPP_RExecute Text 200 UC: Null=True Result: Call Operator
AJPP_RElse Long Integer 4 UC: Null=True Result: else 1=halt 2=ignore 3=JP abend
AJPP_RRepMTimes Long Integer 4 UC: Null=True Result: number of maximum repeats
AJPP_RRepWait Long Integer 4 UC: Null=True Result: time between repeats
AJPP_RRepTimes Long Integer 4 UC: Null=True Result: repeat counter
AJPP_MrtMethod Long Integer 4 UC: Null=True Method for Max. Runtime (bitmask) 0=no audit, 1=fix in seconds, 2=fix time, 4=ERT+xx%, 256=Cancel, 512=Start Object, 1024=JP overwrites Object-Settings
AJPP_Mrt Long Integer 4 UC: Null=True Max. runtime in sec.
AJPP_MrtTime Text 6 UC: Null=True Max. runtime in time ddhhmm
AJPP_MrtErt Integer 2 UC: Null=True MRT=ERT+xx%
AJPP_MrtExecute Text 200 UC: Null=True Object to start
AJPP_TcpATime Text 6 UC: Null=True AFTER TIME > time
AJPP_TcpExecute Text 200 UC: Null=True Object to start
AJPP_Srt Long Integer 4 UC: Null=True Min. runtime in sec.
AJPP_SrtErt Integer 2 UC: Null=True SRT=ERT+xx%
AJPP_TaskIdnr Long Integer 4 UC: Null=True AH_IDNR of the task, -1 if there is no task (inactive); Ext: AH_IDNR which satisfied this condition
AJPP_TcpATimetTZ Text 8 UC: Null=True Timezone for time check point
AJPP_ErlstStTimeTZ Text 8 UC: Null=True Timezone for erleast start time
AJPP_LtstTimeTZ Text 8 UC: Null=True Timezone for latest time
AJPP_MrtTZ Text 8 UC: Null=True Timezone for max. Runtime when a fixed time is used
AJPP_RExecFlag Integer 2 UC: Null=True Result: 0=execute after each unsuccessful execution, 1=execute only after all retries are unsuccessful
AJPP_LDate Date/Time 8 UC: Null=True Only UC_SYSTEM_SCHEDULE: logical date of this task
AJPP_PreCntExt Integer 2 UC: Null=True number of external predecessors (AJPPA) of this AJPP
AJPP_ParentObject Text 200 UC: Null=True Only EXTERNAL: Jobplan Name
AJPP_ExtWhen Text 30 UC: Null=True External Precondition: (Status)
AJPP_ExtSLTType Text 1 UC: Null=True External Precondition: Satisfaction Lead Time Type: 0=since last run, 1=after jop plan start, 2=within hh:mm
AJPP_ExtSLTWithin Long Integer 4 UC: Null=True External Precondition: Time in Seconds
AJPP_ExtElse Text 1 UC: Null=True External Precondition: Else: 0=Wait, 1=Skip, 2=JP Abend
AJPP_ExtElseAlarm Text 1 UC: Null=True External Precondition: Else Alarm: 0=no, 1=yes
AJPP_ExtTimeout Long Integer 4 UC: Null=True External Precondition: Timeout in Seconds
AJPP_ExtTimeoutE Text 1 UC: Null=True External Predondition: Timeout Else: 0=Wait, 1=Skip, 2=JP Abend
AJPP_ExtTimeoutA Text 1 UC: Null=True External Precondition: Timeout Alarm: 0=no, 1=yes
AJPP_ExtExecute Text 200 UC: Null=True External Precondition: Alarm Object
AJPP_TimeoutFlag Byte 1 UC: Typ=Boolean Null=True External Precondition: Timeout On=1, Off=0
AJPP_ErlstStTimeT Date/Time 8 UC: Null=True Earliest start time (timestamp)
AJPP_CmtFlag Byte 1 UC: Typ=Boolean Null=True 0/1 flag for menue prompting + flag in runnr# field
AJPP_Alias Text 200 UC: Null=True Alias Name for ProcessFlow task
AJPP_ParentAlias Text 200 UC: Null=True Alias Name for ProcessFlow task in ExternalDependencies
AJPP_ShowPrompt Byte 1 UC: Typ=Boolean Null=True Prompt will be shown, or not
AJPP_PromptAtGen Byte 1 UC: Typ=Boolean Null=True Prompt at Processflow-Generation or at Job-Generation
AJPP_BranchType Integer 2 UC: Null=True position (branch) of the object in IF: 1=true; 2=false; or FOREACH: 1=LoopPath; 2= EndPath
AJPP_RunPerPatch Long Integer 4 UC: Typ=Boolean Null=True Flag, if Task is running per Patch
AJPP_RollbackFlag Byte 1 UC: Typ=Boolean Null=True Rollback is enabled for task (overrides AH Flag)
AJPP_RunPerTarget Integer 2 UC: Null=True Run per Deployment Target (1=serial, 2=parallel)
AJPP_SubType Text 8 UC: Null=True OType specific SubType


Indexes:

Name Fields
NK_AJPP_Object AJPP_Object, AJPP_AH_Idnr, AJPP_JobStatus, AJPP_EndTime, AJPP_TaskIdnr
NK_AJPP_RefNr AJPP_RefNr, AJPP_AH_Idnr
NK_AJPP_TaskIdnr AJPP_TaskIdnr, AJPP_AH_Idnr
PK_AJPP AJPP_AH_Idnr, AJPP_Lnr


Return to the Index File