dbo.JobQueue
Job queue
TableType TUsage WORKRows 1075SizeMB 4.4
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Job | varchar(38) | no | Process step | PKUID |
UID_JobSameServer | varchar(38) | yes | Base step (optimized load operation) | FKUID |
UID_Tree | varchar(38) | no | Process | UID |
Queue | nvarchar(256) | no | Executing server | |
ComponentClass | nvarchar(400) | yes | Component | |
ExecutionType | nvarchar(32) | yes | Exe type | |
ComponentAssembly | nvarchar(510) | yes | File name | |
TaskName | nvarchar(128) | no | Process task | |
ParamIN | nvarchar(-1) | yes | Input parameter | |
Ready2EXE | nvarchar(64) | no | Execution status | limited |
StartAt | datetime(8) | yes | Start time | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
Retries | int(4) | yes | Retries | |
Priority | int(4) | yes | Priority | |
DeferOnError | bit(1) | yes | Wait mode on error | |
MinutesToDefer | int(4) | yes | Latency [min] | |
UID_JobError | varchar(38) | yes | Successor (error) | UID |
UID_JobSuccess | varchar(38) | yes | Successor (success) | UID |
IgnoreErrors | bit(1) | yes | Ignore errors | |
MaxInstance | int(4) | yes | Max. instances | |
JobChainName | nvarchar(510) | no | Process name | |
ProcessTracking | bit(1) | yes | Process tracking | |
IsSplitOnly | bit(1) | yes | Split processing | |
WasError | bit(1) | yes | Processing error | |
ErrorNotify | bit(1) | yes | Notification (error) | |
NotifyAddress | nvarchar(-1) | yes | Recipient email address [failure] | |
NotifySubject | nvarchar(-1) | yes | Subject [failure] | |
NotifyBody | nvarchar(-1) | yes | Message [failure] | |
NotifySender | nvarchar(-1) | yes | Sender email address [error] | |
SuccessNotify | bit(1) | yes | Notification (success) | |
NotifyAddressSuccess | nvarchar(-1) | yes | Recipient email address [success] | |
NotifySubjectSuccess | nvarchar(-1) | yes | Subject [success] | |
NotifyBodySuccess | nvarchar(-1) | yes | Message [success] | |
NotifySenderSuccess | nvarchar(-1) | yes | Sender email address [success] | |
IsRootJob | bit(1) | yes | Base step | |
GenProcID | varchar(38) | no | Process ID | FKUID |
XTouched | nchar(2) | yes | Processing status | |
IsToFreezeOnError | bit(1) | yes | Stop on error | |
LimitationCount | int(4) | yes | Threshold value (disable) | |
UID_JobOrigin | varchar(38) | yes | Process step (Original) | UID |
BasisObjectKey | varchar(138) | yes | Base object key | |
ErrorMessages | nvarchar(-1) | yes | Error message | |
LimitationWarning | int(4) | yes | Threshold value (warning) | |
LogMode | varchar(8) | yes | Log mode | limited |
IsForHistory | bit(1) | yes | Process history | |
IsNoDBQueueDefer | bit(1) | yes | No DBQueue wait |
Relations
| FK | From | To |
|---|---|---|
| No FK rows in snapshot. | ||
Triggers
QBM_TDJobqueue SQL_TRIGGER
QBM_TIJobqueue SQL_TRIGGER
QBM_TUJobqueue 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.DPR_FGIProjectionRootRunning | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobCreatedExists | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueExistsPending | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueExistsPending | SQL expression dependency | dbo · UID_Job · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueExistsPending | SQL expression dependency | dbo · UID_Tree · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueExistsPending | SQL expression dependency | dbo · ParamIN · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueExistsPending | SQL expression dependency | dbo · Ready2EXE · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · UID_Job · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · UID_Tree · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · Ready2EXE · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · UID_JobError · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · UID_JobSuccess · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · IsSplitOnly · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · WasError · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · IsRootJob · OBJECT_OR_COLUMN |
| dbo.QBM_FGIJobQueueTopJob | SQL expression dependency | dbo · ErrorMessages · OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationCaseCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQCS_SlotRunner | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobCreate_Mnt | 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_PJobQueueInit | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueInit_i | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueLoad | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobqueueoverViewFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueSetSameServer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobRestart | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobSetRunParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobUnfreeze | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobUpdateState_Bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PSlotResetWhileJobRun_L | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PTrafficLight | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PWorkJobQueueDelete | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PWorkMaintenance | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PPersonDelete_GDPR | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZITShopCheckDecision | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FTDialogProcessReady | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobQueueSetSameServer | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobQueueSetSameServer | SQL expression dependency | dbo · UID_Job · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobQueueSetSameServer | SQL expression dependency | dbo · UID_JobSameServer · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobQueueSetSameServer | SQL expression dependency | dbo · UID_Tree · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobQueueSetSameServer | SQL expression dependency | dbo · UID_JobError · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobQueueSetSameServer | SQL expression dependency | dbo · UID_JobSuccess · OBJECT_OR_COLUMN |
| dbo.DPR_TDDPRSystemSyncDependency | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_TIDPRSystemSyncDependency | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_TUDialogColumn | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_TUDialogTable | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_TUDPRSystemSyncDependency | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIJobqueue | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUJobqueue | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_VFESimulationJobqueue | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_VPWOOrderProvisioningState | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.DPR_FGIProjectionRootRunning | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIJobCreatedExists | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIJobQueueExistsPending | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FGIJobQueueTopJob | source text reference | SQL_SCALAR_FUNCTION |
| dbo.ATT_PAttestationCaseCreate | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDBQCS_SlotRunner | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PDialogProcessShrink_3 | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobCreate | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobCreate_Mnt | source text reference | creates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling |
| 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_PJobQueueInit | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobQueueInit_i | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobQueueLoad | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobqueueoverViewFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobQueueSetSameServer | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobRestart | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobSetRunParameter | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobUnfreeze | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobUpdateState_Bulk | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.QBM_PSlotResetWhileJobRun_L | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PTrafficLight | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PWorkJobQueueDelete | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PWorkMaintenance | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZProcessMarkDelete | source text reference | has TRY/CATCH error handling |
| dbo.QER_PPersonDelete_GDPR | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_ZITShopCheckDecision | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_FTDialogProcessReady | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.QBM_FTJobQueueSetSameServer | source text reference | SQL_TABLE_VALUED_FUNCTION |
| dbo.DPR_TDDPRSystemSyncDependency | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.DPR_TIDPRSystemSyncDependency | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.DPR_TUDialogColumn | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.DPR_TUDialogTable | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.DPR_TUDPRSystemSyncDependency | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIJobqueue | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUJobqueue | source text reference | uses session context values, has TRY/CATCH error handling |
| 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-common-customizer-vi-common-customizer-jobqueue.cs | decompiled C# reference | classes JobQueue, _003C_003Ec__DisplayClass4_0, _003C_003Ec__DisplayClass5_0; methods _003C_DeleteTree_003Eb__0, _003C_DeleteTrees_003Eb__0, MoveNext, SetStateMachine, _ResetFrozen, _RepairUidSameServer; references ESet, JobChain, JobQueue; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcbase.cs | decompiled C# reference | classes DCBase, Ready2Exe; methods SelectJob, GetNodeState, IsAnySelectedJob, ProcessSelectedJobs, ConfigureToolTip, GetJobState; references ESet, JobChain, JobQueue; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-jobqueueinfo-vi-tools-jobqueueinfo-dcjobchains.cs | decompiled C# reference | classes DCJobChains; methods ToolTipError_Popup, RefreshData, OnHandleDestroyed, _LoadFormSettings, _SaveFormSettings, _ClearTree; references ESet, JobChain, JobParameter, JobQueue, JobTreeParamColl; markers reads entity values, writes 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 |
| cs-qbm-operations-compositionapi-server-plugin-qbm-compositionapi-job-jobqueueeditapi.cs | decompiled C# reference | classes JobQueueEditApi, _003C_003Ec__DisplayClass0_0; methods MoveNext, SetStateMachine, _003CBuild_003Eb__0, _003CBuild_003Eb__1, Build, HandleJobAsync; references ESet, JobQueue; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-qbm-operations-compositionapi-server-plugin-qbm-compositionapi-operations-qbm-queue-reactivatejob.cs | decompiled C# reference | classes QBM_Queue_ReactivateJob, ReactivateJobInput; methods Build; references ESet, JobQueue; markers reads entity values, references DB/Dialog objects, Job/process related markers |