Show TOC

Background documentationJob Filter Columns Locate this document in the navigation structure

 

The following columns are available for the use in job filters for user defined SQL:

Columns

Description

Behavior

Determines the type of job, 0 and 1 are foreground jobs,{2} stands for background jobs

ChildOrder

Order of the job in the parent/child relationship

CreationTime

Time of creation

CreationTimeZone

Time zone at creation time

Description

Job description, display name

ForcedProcessServer

Value of the ForcedProcessServer scheduling parameter

HoldOnSubmit

Value of the HoldOnSubmit scheduling parameter

JobChainCall

Is this job a job chain job?

JobChainStep

Is this job a job chain step?

JobDefinition

The job definition of the job

JobGroup

The job group, used in recurrences

JobId

The unique id of the job

JobTimeZone

The time zone of the job

KeepExpiration

Job expiration

KillSignal

The kill signal used to kill the job.

LastModificationTime

The last modification time of the job

LastModifierSubject

The last modifier

MinimumOpenDuration

The minimum number of seconds that should be available in the time window of the Job, the Job's Queue or the intersection of both, before this job will be submitted

NextRecalculation

The next date on which the scheduled start time needs to be recalculated

NextSubmitBaseTime

The time that will be used as a start time for the calculation of the next Requested Start Time for a Job with a submit frame, or for the Requested Start Time of a new Job where the Job has an infinite Recurrence Pattern

NumChildJobs

The number of child jobs

NumJobFiles

Number of job files

NumJobLocks

Number of job locks

NumJobMetaData

How many JobMetaData does this Job have?

NumJobNotes

Number of job notes

NumJobParameters

Number of job parameters

NumJobRaiseEvents

Number of job raise events

NumJobWaitEvents

Number of job wait events

OwnerSubject

Owner of the job

ParentJob

The parent job, if it exists

PreviousProcessServer

The previous process server that this job was due to run on, but should be excluded (if possible) from running on next dispatch

Priority

The priority of the job

ProcessServer

The process server of the job

Queue

The queue of the job

QueueOrder

The order in the queue of the job

RemoteCreationTime

The creation time of the job in the remote system

RemoteEvent

The remote event

RemoteId

The remote unique identifier

RemoteRunEnd

The remote end time of the job

RemoteRunStart

The remote start time of the job

RemoteStatus

The remote status

RemoteSystem

The remote system

RequestedStartTimeInternal

The internal start time

RequestedStartTimeType

Has the Requested Start Time been explicitly set by the user, or has it been inherited from the Job's parent

RequestedStatus

The requested status of the job, stored so that it can be accessed (and set back to) during actions

RestartCount

The number of times the job was restarted

RestartJobId

The job id of the job that restarted this job

ReturnCode

The return code of the job

RunEnd

The end time of the job

RunStart

The start time of the job

RuntimeExpiration

The date on which action will be taken if the job has not completed

SAPNWCallbackVariant

SAP NetWeaver callback variant.

ScheduledStartTime

The scheduled start time of the job

SearchDescription

The description converted to upper-case, used for searching.

Status

The current status of the job

StepIteration

The iteration starts at 1 (one). It is incremented when the steps are re-submitted when the current step moves backwards due to a status handler

SubmitFrame

The submit frame of the job

TimeWindow

The time window of the job

TimeWindowTimeZone

The time zone of the time window attached to the job

UniqueId

The unique id of the job