dbo.JobTask
Process tasks
TableType TUsage CONFIGURATIONRows 131SizeMB 0.112
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_JobTask | varchar(38) | no | Process task | PKUID |
UID_JobComponent | varchar(38) | yes | Component | FKUID |
TaskName | nvarchar(128) | yes | Name | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
MaxInstance | int(4) | yes | Max. instances | |
ExecutionType | nvarchar(32) | no | Exe type | limited |
IsEndOfSubTree | bit(1) | yes | Last step in the partial process tree | |
RunningOS | nvarchar(32) | no | Operating system class | limited |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key | |
Description | nvarchar(510) | yes | Description | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
IsExclusivePerObject | bit(1) | yes | Exclusive per object | |
IsDBConnectNeeded | bit(1) | yes | Direct database connection required | |
IsNoDBQueueDefer | bit(1) | yes | No DBQueue wait |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL135 | JobTask.UID_JobComponent | JobComponent.UID_JobComponent |
| QBM_RFRL137 | JobParameter.UID_JobTask | JobTask.UID_JobTask |
| QBM_RFRL138 | Job.UID_JobTask | JobTask.UID_JobTask |
Triggers
GEN_T2983586312E03106FE3C3740F SQL_TRIGGER
GEN_T586DF4E208E44C89D15DE1D46 SQL_TRIGGER
QBM_TDAssembly_JobTask SQL_TRIGGER
QBM_TDJobTask SQL_TRIGGER
QBM_TIAssembly_JobTask SQL_TRIGGER
QBM_TIJobTask SQL_TRIGGER
QBM_TUAssembly_JobTask SQL_TRIGGER
QBM_TUJobTask 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_FTJobCreateDBParameter | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · UID_JobTask · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · UID_JobComponent · OBJECT_OR_COLUMN |
| dbo.QBM_FTJobCreateDBParameter | SQL expression dependency | dbo · TaskName · OBJECT_OR_COLUMN |
| dbo.QBM_FCVJobParamOptions | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_FCVListToJobParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueLoad | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZJobPerformanceFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T586DF4E208E44C89D15DE1D46 | SQL expression dependency | OBJECT_OR_COLUMN |
| JobComponent | referenced by foreign key from table | QBM_RFRL135: JobTask.UID_JobComponent -> JobComponent.UID_JobComponent |
| JobParameter | foreign key references table | QBM_RFRL137: JobParameter.UID_JobTask -> JobTask.UID_JobTask |
| Job | foreign key references table | QBM_RFRL138: Job.UID_JobTask -> JobTask.UID_JobTask |
| dbo.QBM_FTJobCreateDBParameter | source text reference | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dbo.QBM_FCVJobParamOptions | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_FCVListToJobParameter | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_PJobCreate | source text reference | creates object-layer jobs via QBM_PJobCreate*, 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_ZJobPerformanceFill | source text reference | uses session context values, has TRY/CATCH error handling |
| cs-vi-db-compile-vi-db-compile-dialogjobgenassemblybuilder.cs | decompiled C# reference | classes DialogJobGenAssemblyBuilder, _ValueReplacer, _003C_003Ec__DisplayClass21_0, _003C_003Ec__DisplayClass23_0; methods Replace, _ReplaceMatch, _003C_GenerateEventsAsync_003Eb__0, _003C_GenerateJobAsync_003Eb__0, MoveNext, SetStateMachine; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-db-compile-vi-db-compile-sourcegenerators-jobssourcegenerator.cs | decompiled C# reference | classes JobsSourceGenerator, JobsAssemblyGenerator, _PreloadTable, _ValueReplacer; methods _003C_ReplaceMatchAsync_003Eb__0, MoveNext, SetStateMachine, _CreateRegPattern, _CreateRegVersion, ReplaceAsync; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |