/SOMO/JOSCHEDL - Job scheduling table for business process monitoring

Job scheduling table for business process monitoring information is stored in SAP table /SOMO/JOSCHEDL.
It is part of development package /SOMO/MA_6X_MAIN in software component SV-SMG-SDD. This development package consists of objects that can be grouped under "Release >=6.XX: Solution Monitoring: Data Suppliers".

Fields for table /SOMO/JOSCHEDL

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SOLUTIONSolution IDXCHAR100
SIDSYSTEM: SAP-System IdentifikationXCHAR6
JOBMONIDMonitoring ID for the jobXCHAR40
PCOUNTERCounter parallel jobsXINT44
JCOUNTERJob NumberXINT44
STEPCOUNTKennummner eines Job-StepsXINT44
SCHEDULEDATEJob schedule for dayXDATS16
CLIENTMandantCHAR6
EXECUSERUser executes jobsCHAR24
JOBNAMECHAR64
JOBCOUNTCHAR16
JOBMONSTATCHAR2
PROGNAMEName eines Programms innerhalb eines Steps (z.B. Report)CHAR80
VARIANTName einer Variante innerhalb eines StepsCHAR28
XPGPROGName des externen Programms (evtl. inkl. Zugriffspfad)CHAR256
XPGPARAMSParameter des externen Programms (als eine Zeichenkette)CHAR510
PREC_JOBNAMEName of processor jobCHAR64
EVENTIDEreignisse der HintergrundverarbeitungCHAR64
EVENTPARMParameter eines Batch-Events (z.B. Jobname/Jobcount )CHAR128
SDLSTRTTMUhrzeit einer Job- bzw. Step-EinplanungTIMS12
STRTDATEStart DateDATS16
STRTTIMEStart TimeTIMS12
STATUSStatusCHAR2
ENDDATEEnd DateDATS16
ENDTIMEEnd TimeTIMS12
SENDDATEScheduled end dateDATS16
SENDTIMEScheduled end timeTIMS12
DURATIONActual DurationINT44
BPROCESSOBJNOObject no for business processNUMC20
BPROCSTEPOBJNOObject no for process stepNUMC20
PARAPROCParallel ProcessingCHAR2
NUMPARAJOBNumber of parallel processed jobsINT44
JOBLOGANAJob log analysis requieredCHAR2
PTIMEWINSPlanned time window startTIMS12
PTIMEWINEPlanned time window endTIMS12
JOBLOGTemSe Objekt NameCHAR40
CRITICALCritical jobCHAR2
STARTDELAYDelay startINT44
ENDDELAYdelay endINT44
ANUMPARAJOBActual number of parallel jobsINT44
CHGTIMELast change timeTIMS12
CHGDATELast change dateDATS16
.INCLUDE/SOMO/CURRENT_ALERTS0
CHGALERTCHAR20
ALERTDELAYCHAR2
DELAYMSGNOCHAR6
ALERTWINDOWCHAR2
WINDOWMSGNOCHAR6
ALERTDELENDCHAR2
DELENDMSGNOCHAR6
ALERTDURATIONCHAR2
DURATIONMSGNOCHAR6
ALERTSTATUSCHAR2
STATUSMSGNOCHAR6
ALERTPARACHAR2
PARAMSGNOCHAR6
ALERTLOGCHAR2
ALERTNOTSTARTEDAlert Job not startedCHAR2
CUSSTRTTMCustomizing start timeTIMS12
STARTDELAYTECHTechnical start delayINT44
EXTFLAGFlag for external scheduled jobsCHAR2
MSG1COUNTERCounter 1 for certain message variablesINT44
MSG2COUNTERCounter 2 for certain message variablesINT44
MSG3COUNTERCounter 3 for certain message variablesINT44
NAM_RULERule for custom jobname determinationNUMC6
CHKTIMNOTSTARTEDChecktime for job not started alerttypeTIMS12
ALERTJOBACTIVEAlert Job activeCHAR2
JOBACTIVEMSGNOMessage number of alert type job activeCHAR6
NOTACTIVETIMETime job not active in minutesINT44
LASTJOBNAMEName of previous job - used for job active alert typeCHAR64
LASTJOBCOUNTJob count of previous job - used for job active alert typeCHAR16
LASTSTATUSJob status of previous job - used for job active alert typeCHAR2
LASTENDDATEJob end date of previous job - used for job active alert typDATS16
LASTENDTIMEJob end time of previous job - used for job active alert typTIMS12
SIDLONGName of SAP SystemSYSYSIDCHAR16
JOBTYPEType of job space, BH, BE, JH, JECHAR4
RJOBMONIDReference Job MonidCHAR40
CHAIN_IDBW Chain IDCHAR50
TYPEBW Process TypeCHAR20
VARIANTEBW Chain VarianteCHAR60
LOG_IDLog Id BW Process ChainCHAR50
REC_SENDNumber of records send (e.g. by BW process chain)INT44
REC_INSRNumber of records inserted (e.g. by BW process chain)INT44
ARECPROCAlert records processedCHAR2
RECPROCMSGOAlert message records processedCHAR6
PROCSTATUSProcessing status (e.g. by BW process chain / element)CHAR4
AFAILSTATAlert failed process statusCHAR2
FAILSTATMSGNOAlert message failed process statusCHAR6
INFO_PKGNumber of info packages processedINT44
AINFORECAlert info packages processedCHAR2
INFORECMSGOAlert message info packages processedCHAR6
LASTMONDATELast monitoring date for the jobDATS16
ALERTTYPELEVELIndicator if an alert type is selected for Job or job stepCHAR40
STRTDATESTEPStart date of job step aoccording to job logDATS16
STRTTIMESTEPStart time of job step aoccording to job logTIMS12
STATUSSTEPJob step status according to job logCHAR2
ENDDATESTEPEnd date of job step aoccording to job logDATS16
ENDTIMESTEPEnd time of job step aoccording to job logTIMS12
CHGALERT2Log key for alert changesCHAR40
Privacy Policy