Back to OIM Explorer

QBMDBQueueTaskMetric

Generated table/view profile from relation entities, typed edges, trigger evidence, source references, and object-layer metadata.

1relations

0typed edges

0triggers

0queue edges

0method edges

0event edges

Verified DialogTable / DialogColumn Metadata

Live read-only DialogTable metadata describes this as a Database Agent Service task-processing snapshot. DialogColumn metadata documents queue capacity and processing columns such as CountInDBQueue, CountProcessing, CurrentBulk, IsBulkEnabled, MaxInstanceEffective, PathLength, ProcedureName, RestoreDelay, and task predecessor/follower columns.

Database Agent Service snapshotDisplayName

WORKUsageType

UID_TaskDialogTable PK

337CountRows

DialogTable remarks: Snapshot of the task processing of the Database Agent Service.

Column Descriptions

Column	Caption	DialogColumn commentary	Flags / type
`UID_Task`	DBQueue Processor task	Unique task identifier.	PK, UID, foreign key
`ProcedureName`	Procedure	Procedure that executes the task.	varchar(61)
`CountInDBQueue`	Number of tasks	Number of entries in the DialogDBQueue table per request.	int
`CountProcessing`	Number in status PROCESSING	Number of processes in execution status "PROCESSING".	int
`CurrentBulk`	Current number (bulk processing)	Current number of jobs to be processed in one slot.	int
`IsBulkEnabled`	Bulk processing	Defines whether the procedure is suitable to bulk processing.	bit
`MaxInstanceEffective`	Max. instances	Maximum number of slots that can be filled with this job in parallel.	int
`PathLength`	Calculated weighting	Calculated weighting to determine the jobs to be processed.	int
`SlotInformation`	Slots	Listing of slots assigned to the task, including processing status and count.	varchar(max)
`UID_TaskAutomatedFollower`	Task follower	Follow-up function.	UID, foreign key
`UID_TaskAutomatedPredecessor`	Task predecessor	Predecessor function.	UID, foreign key
`UID_TaskParent`	Parent task	Parent task identifier.	UID, foreign key

Indexes

Clustered primary key on UID_Task.

Triggers

No triggers returned by live metadata pull for this table.

Verified Relations

QBM_PDBQueueInsert_Bulk validates @UID_Task against QBMDBQueueTaskMetric for temp-queue and pond-buffer paths.
QBM_PDBQueueInsert_Int reads task metadata from QBMDBQueueTaskMetric before inserting into DialogDBQueue.
QBM_FTDBQCSOverviewLoad reads QBMDBQueueTaskMetric.MaxInstanceEffective and compares aggregate capacity with dbo.QBM_FGIDBQueueSlotsMax().

Typed Edges

Type	Source	Target	Evidence
No typed edges matched.

Related Evidence

Scalar Function

dbo.QBM_FGICutOffTaskExists

Scalar Function.

Open source