dbo.JobHistory
Process history
TableType TUsage HISTORYRows 19015SizeMB 66.4
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_JobHistory | varchar(38) | no | Process history | PKUID |
UID_Job | varchar(38) | no | Process step | UID |
UID_Tree | varchar(38) | no | Process | UID |
Queue | nvarchar(256) | yes | Server | |
ComponentClass | nvarchar(400) | yes | Class | |
ComponentAssembly | nvarchar(510) | yes | Component | |
TaskName | nvarchar(128) | yes | Process task | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
ParamIN | nvarchar(-1) | yes | Input parameter | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
Priority | int(4) | yes | Priority | |
EndedAt | datetime(8) | yes | Completed | |
StartAt | datetime(8) | yes | Start time | |
JobChainName | nvarchar(510) | yes | Process name | |
WasError | bit(1) | yes | Processing error | |
IsRootJob | bit(1) | yes | Base step | |
UID_JobError | varchar(38) | yes | Next step on error | UID |
UID_JobSuccess | varchar(38) | yes | Next step on success | UID |
XTouched | nchar(2) | yes | Processing status | |
GenProcID | varchar(38) | no | Process ID | FKUID |
UID_JobOrigin | varchar(38) | yes | Process step (Original) | UID |
BasisObjectKey | varchar(138) | yes | Base object key | |
ErrorMessages | nvarchar(-1) | yes | Error message | |
ReadyForDeleteOrExport | int(4) | yes | Free for further processing | limited |
LogMode | varchar(8) | yes | Log mode | limited |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
GEN_T2A11FB74BA51941A4D795947F SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_PDialogProcessShrink_fill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PF84975544A6AEABC94405E1_a | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueDelete | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueDelete_Bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PProcessGroupDelete | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PWorkHistoryDelete | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZProcessMarkDelete | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZProgressViewShrinkReset | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FTDialogProcessReady | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_VProvBaseView | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDialogProcessShrink_3 | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDialogProcessShrink_fill | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PF84975544A6AEABC94405E1_a | source text reference | SQL_STORED_PROCEDURE |
| dbo.QBM_PJobQueueDelete | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobQueueDelete_Bulk | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PProcessGroupDelete | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PWorkHistoryDelete | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZProcessMarkDelete | source text reference | has TRY/CATCH error handling |
| dbo.QBM_FTDialogProcessReady | source text reference | SQL_TABLE_VALUED_FUNCTION |
| cs-common-customizer-vi-common-customizer-dialogtable.cs | decompiled C# reference | classes DialogTable, _003C_003Ec__DisplayClass4_0; methods _003C_ConfigureColumns_003Eb__0, MoveNext, SetStateMachine, OnSavingAsync, _ConfigureColumns, OnSavedAsync; references DialogCalendar, DialogColumn, DialogDBQueue, DialogMultiLanguage, DialogNotification, DialogProcess; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcjoberrors.cs | decompiled C# reference | classes DCJobErrors; methods SelectJob, RefreshData, Dispose, OnHandleDestroyed, InitializeComponent, _LoadFormSettings; references ESet, JobChain, JobHistory, JobQueue; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |