dbo.Job
Process steps
TableType TUsage CONFIGURATIONRows 625SizeMB 1.128
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_Job | varchar(38) | no | Process step | PKUID |
UID_QBMServerTag | varchar(38) | yes | Server function | FKUID |
UID_JobChain | varchar(38) | yes | Process | FKUID |
UID_JobTask | varchar(38) | yes | Process task | FKUID |
Name | nvarchar(510) | yes | Name | |
Description | nvarchar(2046) | yes | Description | |
GenCondition | nvarchar(-1) | yes | Generating condition | |
Retries | int(4) | yes | Retries | |
UID_SuccessJob | varchar(38) | yes | Successor (success) | FKUID |
UID_ErrorJob | varchar(38) | yes | Successor (error) | FKUID |
Priority | int(4) | yes | Priority | |
ServerDetectScript | nvarchar(-1) | yes | Script for server selection | |
DeferOnError | bit(1) | yes | Wait mode on error | |
MinutesToDefer | int(4) | yes | Latency [min] | |
IgnoreErrors | bit(1) | yes | Ignore errors | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
ProcessTracking | int(4) | yes | Process information | limited |
ProcessDisplay | nvarchar(-1) | yes | Process information term | |
ProcessInfoLevel | int(4) | yes | Depth of detail | limited |
IsSplitOnly | bit(1) | yes | Split processing | |
ErrorNotify | bit(1) | yes | Notification (error) | |
NotifyAddress | nvarchar(-1) | yes | Recipient email address | |
NotifySubject | nvarchar(-1) | yes | Subject | |
NotifyBody | nvarchar(-1) | yes | Message | |
NotifySender | nvarchar(-1) | yes | Sender email address | |
SuccessNotify | bit(1) | yes | Notification (success) | |
NotifyAddressSuccess | nvarchar(-1) | yes | Recipient email address | |
NotifySubjectSuccess | nvarchar(-1) | yes | Subject | |
NotifyBodySuccess | nvarchar(-1) | yes | Message | |
NotifySenderSuccess | nvarchar(-1) | yes | Sender email address | |
XTouched | nchar(2) | yes | Processing status | |
IsToFreezeOnError | bit(1) | yes | Stop on error | |
PreProcessorCondition | nvarchar(510) | yes | Preprocessor condition | |
PreCode | nvarchar(-1) | yes | Pre-script for generating | |
XObjectKey | varchar(138) | no | Object key | |
IsErrorLogToJournal | bit(1) | yes | Log errors to journal | |
IsDeactivatedByPreProcessor | bit(1) | yes | Deactivated by preprocessor | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
LogMode | varchar(8) | yes | Log mode | limited |
PriorityDefinition | nvarchar(-1) | yes | Priority definition | |
IsForHistory | bit(1) | yes | Process history | |
IsNoDBQueueDefer | bit(1) | yes | No DBQueue wait |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL138 | Job.UID_JobTask | JobTask.UID_JobTask |
| QBM_RFRL167 | Job.UID_JobChain | JobChain.UID_JobChain |
| QBM_RFRL362 | Job.UID_QBMServerTag | QBMServerTag.UID_QBMServerTag |
Triggers
GEN_T1A8B4C61A7D279F250ED89AD5 SQL_TRIGGER
GEN_T2829B0C09976CD02A8DCCDF37 SQL_TRIGGER
GEN_T3E9FF91784D40BB4CAFAE33D8 SQL_TRIGGER
GEN_T5ACC5637C02ABEFB39647FC91 SQL_TRIGGER
QBM_TDAssembly_Job SQL_TRIGGER
QBM_TIAssembly_Job SQL_TRIGGER
QBM_TIJob SQL_TRIGGER
QBM_TUAssembly_Job SQL_TRIGGER
QBM_TUJob 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_PJobRestart | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobUpdateState_Bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropJob | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZPrePropJobChain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T10E64B58F9ACB13021EA360EF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T15E4B8709219A3DA06BC3C657 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1A8B4C61A7D279F250ED89AD5 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2587AF58190E7B24F5F73E4D6 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2829B0C09976CD02A8DCCDF37 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2C5B5417A740C95F0D379A5A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3E9FF91784D40BB4CAFAE33D8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5ACC5637C02ABEFB39647FC91 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TDAssembly_JobRunparameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIAssembly_JobRunparameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUAssembly_JobRunparameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUJobParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| JobTask | referenced by foreign key from table | QBM_RFRL138: Job.UID_JobTask -> JobTask.UID_JobTask |
| JobChain | referenced by foreign key from table | QBM_RFRL167: Job.UID_JobChain -> JobChain.UID_JobChain |
| QBMServerTag | referenced by foreign key from table | QBM_RFRL362: Job.UID_QBMServerTag -> QBMServerTag.UID_QBMServerTag |
| dbo.QBM_PJobRestart | 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_ZPrePropJob | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZPrePropJobChain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TDAssembly_JobRunparameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIAssembly_JobRunparameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUAssembly_JobRunparameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TUJobParameter | source text reference | uses session context values, has TRY/CATCH error handling |