dbo.QBMDBQueueTask
DBQueue Processor tasks
TableType TUsage CONFIGURATIONRows 337SizeMB 0.208
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Task | varchar(38) | no | DBQueue Processor task | PKUID |
ProcedureName | varchar(61) | yes | Procedure | |
IsBulkEnabled | bit(1) | yes | Bulk processing | |
XTouched | nchar(2) | yes | Processing status | |
CountParameter | int(4) | yes | Number of parameters | |
XObjectKey | varchar(138) | no | Object key | |
MaxInstance | int(4) | yes | Max. instances | |
UID_TaskAutomatedFollower | varchar(38) | yes | Task follower | FKUID |
UID_TaskAutomatedPredecessor | varchar(38) | yes | Task predecessor | FKUID |
IsNoGenProcIDCheck | bit(1) | yes | Without process ID check | |
UID_TaskParent | varchar(38) | yes | Parent task | FKUID |
QueryForRecalculate | nvarchar(-1) | yes | Query to recalculate | |
IsWithoutTransaction | bit(1) | yes | Without transaction | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
ChangeLimit | int(4) | yes | Limitation | |
ExecutionDelaySeconds | int(4) | yes | Min. time difference [sec] | |
RestoreDelay | int(4) | yes | Min. reactivation time [sec] | |
CustomWeight | float(8) | yes | Weighting | |
BulkLimit | int(4) | yes | Bulk limit |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL326 | QBMDBQueueTaskDepend.UID_TaskPredecessor | QBMDBQueueTask.UID_Task |
| QBM_RFRL340 | QBMConfigParmHasTask.UID_Task | QBMDBQueueTask.UID_Task |
| QBM_RFRL345 | QBMDBQueueTaskHasSchedule.UID_Task | QBMDBQueueTask.UID_Task |
| QER_RFRL4364 | PWODecisionRule.UID_Task | QBMDBQueueTask.UID_Task |
| QER_RFRL4375 | BaseTreeAssign.UID_TaskHardware | QBMDBQueueTask.UID_Task |
Triggers
GEN_T1BFB0891954C70CE98948B1F2 SQL_TRIGGER
GEN_T2776EBBA51F260C8FBA553C5E SQL_TRIGGER
GEN_T39FC96DBDDABBD03234E9F00E SQL_TRIGGER
GEN_T49CDB645E0B9AA79481EF22F4 SQL_TRIGGER
GEN_T5EA3F5D4DCAE8BF115C6714EC SQL_TRIGGER
GEN_T6B6C6AE47AA177A93D791091A 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_FSQXDateSubItemUpdate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FSQXMarkedForDeletionChg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabasePrepareCheck2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueInsert_Int | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PWatchDogPrepare | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropAll | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZRecalculate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZTaskForInactiveTrigger | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FTDBQCSOverviewLoad | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1BFB0891954C70CE98948B1F2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1C03DC4A9DCC31F0518BCDA5C | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E8C7B9758012D8E43DDCB7BD | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T274946567618F8328825E12D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2776EBBA51F260C8FBA553C5E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2B3CD51ADE946530F098BB7CC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T39FC96DBDDABBD03234E9F00E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5EA3F5D4DCAE8BF115C6714EC | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_VDBQueueTaskParentColl | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_VDBQueueTaskParentColl | SQL expression dependency | dbo · UID_Task · OBJECT_OR_COLUMN |
| dbo.QBM_VDBQueueTaskParentColl | SQL expression dependency | dbo · UID_TaskParent · OBJECT_OR_COLUMN |
| dbo.QBMDBQueueTaskPerf_fix | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMDBQueueTaskDepend | foreign key references table | QBM_RFRL326: QBMDBQueueTaskDepend.UID_TaskPredecessor -> QBMDBQueueTask.UID_Task |
| QBMConfigParmHasTask | foreign key references table | QBM_RFRL340: QBMConfigParmHasTask.UID_Task -> QBMDBQueueTask.UID_Task |
| QBMDBQueueTaskHasSchedule | foreign key references table | QBM_RFRL345: QBMDBQueueTaskHasSchedule.UID_Task -> QBMDBQueueTask.UID_Task |
| PWODecisionRule | foreign key references table | QER_RFRL4364: PWODecisionRule.UID_Task -> QBMDBQueueTask.UID_Task |
| BaseTreeAssign | foreign key references table | QER_RFRL4375: BaseTreeAssign.UID_TaskHardware -> QBMDBQueueTask.UID_Task |
| dbo.QBM_FSQXDateSubItemUpdate | source text reference | inserts DBQueue tasks, uses session context values |
| dbo.QBM_FSQXMarkedForDeletionChg | source text reference | inserts DBQueue tasks |
| dbo.QBM_PDatabasePrepareCheck2 | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PDBQueueInsert_Int | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PWatchDogPrepare | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropAll | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_ZRecalculate | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_ZTaskForInactiveTrigger | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QBM_FTDBQCSOverviewLoad | source text reference | SQL_TABLE_VALUED_FUNCTION |