Job Filter Columns 
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 |