dbo.QBM_PDBQCS_SlotFill

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:37.460 · modified 2026-04-14T23:16:09.127 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@SlotNumberintno
@UID_TaskToStartvarcharno
@MaxBulkintno
@CountParameterintno
@SearchPatternvarcharno
@RowsReadFromDBQueueintyes
@RowsFilledIntoCurrentintyes
@WasNoSuccessbityes

Referenced objects

SchemaObjectColumn/minorClass
DialogDBQueueOBJECT_OR_COLUMN
QBM_PDBQCS_CurrentMoveSlotOBJECT_OR_COLUMN
QBM_PExecuteSQLWithRetry_LLPOBJECT_OR_COLUMN
QBM_PJournalOBJECT_OR_COLUMN
QBM_PSessionErrorCleanOBJECT_OR_COLUMN
QBM_PTransactionLevelCheckOBJECT_OR_COLUMN
QBM_YDBQCSCurrentToMoveTYPE
QBMDBQueueCurrentOBJECT_OR_COLUMN
QBMDBQueueTaskMetricOBJECT_OR_COLUMN
dboQBM_FGIDBQueueSlotResetTypeOBJECT_OR_COLUMN

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:16:09.127

has TRY/CATCH error handling

Summary: calls QBM_PJournal, QBM_PTransactionLevelCheck, QBM_PDBQCS_CurrentMoveSlot, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorClean; writes INSERT into, INSERT QBMDBQueueCurrent, UPDATE DialogDBQueue; reads/joins QBMDBQueueTaskMetric, DialogDBQueue, QBMDBQueueCurrent

Declared parameters

ParameterTypeDirection
@SlotNumberintinput
@UID_TaskToStartvarchar(38)input
@MaxBulkintinput
@CountParameterintinput
@SearchPatternvarchar(64)input
@RowsReadFromDBQueueintOUTPUT
@RowsFilledIntoCurrentintOUTPUT
@WasNoSuccessbitOUTPUT

DML targets

INSERT into INSERT QBMDBQueueCurrent UPDATE DialogDBQueue

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: #UIDUmsetz

Variables: @SlotNumber @UID_TaskToStart @MaxBulk @CountParameter @SearchPattern @RowsReadFromDBQueue @RowsFilledIntoCurrent @WasNoSuccess @ErrorInLoadCurrent @DebugLevel @DebugSwitch @Message @SlotNumberSource @SlotNumberTarget @DBQueueToMove @RowsMoved @SQLMoveCmd @FehlerImExec @TracePathlength @TraceMessage @procid @ROWCOUNT @SlotnumberTarget @message @Debuglevel @LockTimeout_ms @MaxWaitTimeForLock_s @ProcIDForJournal @HandleErrorSilent @DeadlockPriority @ExecuteWithTransact @ErrorInExecute @TRANCOUNT

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

No reverse dependencies extracted.