GetRunningJobs Method
- Last UpdatedNov 06, 2025
- 3 minute read
Parameters
- entId
- Required. Holds the ID of the entity for which the running jobs are being retrieved.
Return Value
Returns a DataSet that contains records for all the running jobs on the specified entity. If no matching jobs are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
job.* |
All columns from the Job table are included in the DataSet. Additionally, the values from the datetime columns other than the edit_time column are returned in client’s local time by excluding the offset name. For example, an additional column req_finish_time identifying the required finish time derived from req_finish_time_utc for a job is returned in client’s local time, etc. |
|
wo_desc |
A string that is the description of the work order, from the wo.wo_desc column linked to this job. |
|
req_qty |
A double that is the quantity of item required, from the wo.req_qty column linked to this job. |
|
mo_id |
A string that is the ID of the manufacturing order for grouping different final parts, from the wo.mo_id column linked to this job. |
|
item_desc |
A string that is the description of the item, from the item.item_desc column linked to this job. |
|
state_desc |
A string that is the description of the job state, from the job_state.state_desc column linked to this job and thus the job’s state. |
|
color |
A long value that identifies the background color that should be displayed on the user interface when this job is selected. |
|
ent_name |
A string that is the name of the entity, from the ent.ent_name column linked to the job.target_sched_ent_id column for this job. |
|
run_ent_name |
A string that is the name of the entity, from the ent.ent_name column linked to the job.run_ent_id column for this job. |
|
item_spare1 |
A string that is the contents of the user-defined item spare1 field, from the item.spare1 linked to the item for this job. |
|
item_spare2 |
A string that is the contents of the user-defined item spare2 field, from the item.spare2 linked to the item for this job. |
|
item_spare3 |
A string that is the contents of the user-defined item spare3 field, from the item.spare3 linked to the item for this job. |
|
item_spare4 |
A string that is the contents of the user-defined item spare4 field, from the item.spare4 linked to the item for this job. |
|
lifetime |
An integer that is the lifetime, in days, of this item before it expires, from the item.lifetime column linked to this item resulting from the job. |
|
num_decimals |
An integer that is the number of decimals for formatting numeric values. |
|
num_decimals_good_pp |
An integer that is the value of the system_attr 326 Max decimals of good piece part entries and is used when the num_decimals column is zero. |
|
description |
A string that is the description of the unit of measurement for this item, from the uom.description linked to this item resulting from the job. |
|
abbreviation |
A string that is the abbreviation for the unit of measurement for this item, from the uom.abbreviation column linked to this item resulting from the job. |
|
def_lot_no |
A string that is the default lot number, from the job_bom.def_lot_no for BOM position 0 linked to this job. |
|
process_id |
A string that is the process ID, from the wo.process_id column linked to the work order from the job. |