JOB is the data table for the Job data.
Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
---|---|---|---|---|---|---|---|---|---|
INR | Internal Unique ID of Job | Text | 8 | 1 | Edit | Yes | Public | ||
COD | Job Code | Text | 6 | 1 | Edit | Yes | Public | JOBTXT | |
NAM | Job Description | Text | 40 | 1 | Edit | Yes | Public | ||
TYP | Type of Repetition of the Job | Text | 1 | 1 | 20 | Edit | Yes | Public | Embedded |
LOWTIM | Earliest Job Execution at HH:MM | Numeric | 4 | 2 | Edit | Yes | Public | ||
HIGTIM | Latest Job Execution at HH:MM | Numeric | 4 | 2 | Edit | Yes | Public | ||
WDY | Day of the Week | Text | 1 | 1 | 20 | Edit | Yes | Public | Embedded |
MDY | Day of the Month | Text | 2 | 1 | 40 | Edit | Yes | Public | Embedded |
LSTBEGDATTIM | Last Execution Begin | Datetime | 15 | 0 | Unknown | Yes | Public | ||
LSTENDDATTIM | Last Execution End | Datetime | 15 | 0 | Unknown | Yes | Public | ||
NXTBEGDATTIM | Next Execution Begin | Datetime | 15 | 0 | Unknown | Yes | Public | ||
TRNTYP | Type of Transaction | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
TRNFRM | Framename / Command | Text | 80 | 1 | Edit | Yes | Public | ||
TRNARG | Argument(s) | Text | 80 | 1 | Edit | Yes | Public | ||
SSNINR | INR of Last SSN Used for Execution | Text | 8 | 1 | Edit | Yes | Public | ||
STA | Status of Job | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
FRQ | Frequency in Minutes | Numeric | 2 | 0 | Edit | Yes | Public | ||
SKPTIM | Skip Execution if not Executed after x Hours | Numeric | 2 | 0 | Edit | Yes | Public | ||
MAXRUNTIM | Max Runtime of Job in Minutes | Numeric | 4 | 0 | Edit | Yes | Public | ||
USR | Job Owner | Text | 8 | 1 | Edit | Yes | Public | ||
VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
CAL | Calendar | Text | 10 | 1 | Edit | Yes | Public | ||
TIMZON | Time zone | Text | 6 | 1 | Edit | Yes | Public | TIMZON | |
ETYFLG | Entitywise reporting | Text | 1 | 1 | Edit | Yes | Public | ||
CURETY | Entity the job is currently executed for | Text | 8 | 1 | Edit | Yes | Public | ||
ETYEXTKEY | Entity owning Job | Text | 8 | 1 | Edit | Yes | Public |
Name | Fields | Properties |
---|---|---|
JOB_COD | COD | |
JOB_ETYEXTKEY | ETYEXTKEY | |
JOB_INR | INR | Unique |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter JOB. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field holds the external used code to identify a job.
This field holds the external code used to identify a job.
Description for job.
Description of job
This field describes the type of automatic repetition of this job (e.g. daily, weekly, monthly). See embedded codetable for details.
This field describes the pattern of recurrence for this job (e.g. daily, weekly, monthly). See embedded codetable for details.
Code | Text |
---|---|
H | every hour |
* | every working day |
+ | every day |
W | every week |
M | every month |
Q | every quarter |
Y | every year |
manual execution | |
R | every x minutes |
O | only once |
P | every x min on work days |
A | half yearly |
Earliest time of the day when this job might be executed.
Earliest time of the day when this job can be executed.
Latest time of the day when this job might be executed. For jobs that are executed more than once per day (i.e. hourly or every x minutes): when this time is reached next execution is scheduled for next day.
Latest time of the day when this job can be executed. Where jobs are executed more than once per day (i.e. hourly or every x minutes), this time signals the end of processing for the day: the next execution is scheduled for the following day.
For 'weekly' jobs only: Day of the week when job is to be executed.
For 'weekly' jobs only, the field identifies the day of the week when the job is to be executed.
Code | Text |
---|---|
< | first working day |
> | last working day |
2 | Monday |
3 | Tuesday |
4 | Wednesday |
5 | Thursday |
6 | Friday |
7 | Saturday |
1 | Sunday |
For jobs that are executed 'monthly' or with longer periods: Day of the month when job is to be executed.
For jobs executed 'monthly' or in longer periods, the field defines the day of the month when the job is to be executed.
Code | Text |
---|---|
< | first working day |
> | last working day |
1 | first |
2 | second |
3 | third |
4 | forth |
5 | fifth |
6 | sixth |
7 | seventh |
first | |
8 | eighth |
9 | ninth |
10 | tenth |
11 | eleventh |
12 | twelfth |
13 | thirteenth |
14 | fourteenth |
15 | fifteenth |
16 | sixteenth |
17 | seventeenth |
18 | eighteenth |
19 | nineteenth |
20 | twentieth |
21 | twentyfirst |
22 | twentysecond |
23 | twentythird |
24 | twentyfourth |
25 | twentyfifth |
26 | twentysixth |
27 | twentyseventh |
28 | twentyeighth |
29 | twentyninth |
30 | thirtieth |
31 | thirtyfirst |
L | last |
Date and time when the job had been started last time.
Date and time when the job was last started.
Date and time when the job had been finished last time.
Date and time when the job was last finished.
Next date and time for which execution is scheduled.
Date and time when job next scheduled.
Specifies, whether TradeDesign transaction or script resp. executable is to be executed by job.
Specifies whether a TradeDesign transaction/script/executable is to be executed by job.
Code | Text |
---|---|
T | Transaction |
E | Executable or Script |
Name of transaction or script or executable to be executed. Name of transaction must not contain path or extensions. Names of script or executable must contain a full path or a path relative to $TD2HOME.
Name of transaction/script/executable to be executed. The name of the transaction should not contain a path or extension.
Arguments to be passed to the transaction/script on execution.
Arguments passed to the transaction/script for execution.
Session in which this job was executed last times (for TRNTYP 'Transaction' only).
Session in which this job was last executed (only for transaction type jobs).
Status of last job execution. See embedded codetable for details.
Status of last job. See embedded codetable for details.
Code | Text |
---|---|
R | Running |
F | Finished |
E | Finished with error |
Never started | |
C | Configuring |
M | Edited |
Frequency of execution in minutes. Only for jobs with type of repetition 'every x minutes'.
Frequency of execution (in minutes). Used only for jobs that can repeat 'every x minutes'.
Optional field. If the contents is not zero it defines the maximum margin between scheduled execution and real execution. After that time the scheduled execution is forwarded to the next time according to the scheduling settings.
Optional field. If not zero the field defines the maximum gap between scheduled and actual execution. After this time, the job is moved to its next scheduled run.
Defines an optional maximum allowed runtime for a job. If this time is set and exceeded the JOBTSK manager marks the job as erroneous and continues with the execution of the next waiting job. There is a global maximum runtime definable within the JOBTSK settings which might take effect if no job limit is defined.
Defines an optional maximum runtime for a job. If this time is set and exceeded the JOBTSK manager marks the job as faulty and continues with the next job. A global maximum runtime can be defined in JOBTSK settings which will take effect if no job limit has been defined.
If set to a non blank value the job will be executed using this user id. A sample usage is to get a fitting user id for Remote Client Printing.
If set to a non blank value the job will be executed using this user id. A sample usage is to get a fitting user id for Remote Client Printing.
This field holds the version counter to keep track of the version history of a JOB entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
Calendar to be used for calculation of next job execution.
Calendar to be used for calculation of next job execution.
The time zone may be set in tdpara.ini (file / system) under TZUser.
The time zone may be set in tdpara.ini “system”, under TZUser.
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
This field holds the external key of the owning entity to identify the logical owner of this entry.
This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
When activated the job is intended to be executed multiple times for all entities the executing user has access to. During the repetitive execution the entity the currently running execution is using is available in the field CURETY.
When the checkbox is set, a multiple execution of this job will take place for all entities visible to the user.
When the ETYFLG is set this field controls the entity the job is currently executing for. When this field is empty, the job should process the full list of entities. During the execution of a job the entity the currently running execution is using is updated in this field. When a job is restarted after an interruption the first entity the job is executed for is taken from this field.
When the ETYFLG is set this field controls the entity the job is currently executing for. When this field is empty, the job should process the full list of entities. During the execution of a job the entity the currently running execution is using is updated in this field. When a job is restarted after an interruption the first entity the job is executed for is taken from this field.