dbo.QBM_ZScheduleStartDashBoard

SQL_STORED_PROCEDURE

Created 2025-06-27T17:58:58.627 · modified 2026-04-14T23:20:29.327 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@SlotNumberintno

Referenced objects

SchemaObjectColumn/minorClass
DialogDashBoardDefOBJECT_OR_COLUMN
QBM_PDBQueueInsert_BulkOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_YDBQueueRawTYPE
QBMDBQueueCurrentOBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1   create   procedure QBM_ZScheduleStartDashBoard (@SlotNumber int ) AS begin set nocount on BEGIN TRY  declare @DBQueueElements_01 QBM_YDBQueueRaw
2 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select r.uid_DialogDashBoardDef as uid, cu.GenProcID
3 from DialogDashBoardDef r join QBMDBQueueCurrent cu with (readpast) on r.UID_DialogSchedule = cu.UID_Parameter and cu.SlotNumber = @SlotNumber  where 
4r.IsInActive = 0 and r.IsAdHoc = 0 and r.IsManual = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboard', @DBQueueElements_01 END TRY BEGIN CATCH
5 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 
6

Module relation graph

Loading module relation graph…

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:20:29.327

inserts DBQueue tasks has TRY/CATCH error handling

Summary: calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins DialogDashBoardDef, QBMDBQueueCurrent

Declared parameters

ParameterTypeDirection
@SlotNumberintinput

DML targets

INSERT into

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

QBM-K-CommonDashboard

Temp tables / referenced variables

Temp: None extracted.

Variables: @SlotNumber @DBQueueElements_01

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.