The following table shows the structure of the JRJOBIMPORT table:
Column name |
Data type |
Description |
|
|---|---|---|---|
id |
INTEGER |
ID of the task |
Autoincrement |
processname |
(N)VARCHAR(50) |
Process name of the instance to be started |
Required field |
version |
INTEGER |
Process version of the instance to be started (0 for the active process version) |
Required field |
step |
INTEGER |
Number of the step to be activated |
Required field |
initiator |
(N)VARCHAR(50) |
Username of initiator |
Required field |
insstring |
(N)VARCHAR(4000) |
Field assignments |
Optional |
subtable_insstring |
(N)VARCHAR(MAX) |
Subtable assignments |
Optional |
summary |
(N)VARCHAR(255) |
Subject |
Optional |
jobfunction |
(N)VARCHAR(50) |
Job Function used for the activated step |
Optional |
username |
(N)VARCHAR(50) |
User used for the activated step |
Optional |
priority |
INTEGER |
Priority of the instance |
Optional |
pool |
INTEGER |
Processing pool |
Optional |
step_escalation_date |
DATETIME |
Escalation date of the first step |
Optional |
incident_escalation_date |
DATETIME |
Escalation date for the full instance |
Optional |
simulation |
INTEGER |
Simulation mode 0: Off |
Optional |
indate |
DATETIME |
The date the instance is to be started on |
Optional |
create_date |
DATETIME |
Date the entry was made into the table |
Optional |
import_date |
DATETIME |
Date of the successful import of the instance |
JobRouter output |
errordesc |
(N)VARCHAR(MAX) |
Error message of the last failed attempt |
JobRouter output |
error_count |
INTEGER |
Allowed amount of failed attempts |
Optional |
incident |
INTEGER |
Number of the started instance |
JobRouter output |
the processid. |
(N)VARCHAR(50) |
Process ID of the started instance |
JobRouter output |
workflowid |
(N)VARCHAR(50) |
Workflow ID of the started instance |
JobRouter output |
task_id |
(N)VARCHAR(50) |
Allows you to enter a unique ID, under which the entry can be found. This value is linked to the task_id column of table JRJOBIMPORTXML. (Filling tables using XML) |
Optional |
jobstart_type |
INTEGER |
Type of the import task 1: File Import task 2: Emai Import task 3: Schedule task |
Optional |
jobstart_log_id |
(N)VARCHAR(36) |
Reference ID of the corresponding entry of the table JRFILEIMPORTLOG |
Optional |
