dbo.QBM_PDBQueueAgentInfoSet

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

Name	Type	Output
`@Ident_QBMDBQueueAgent`	nvarchar	no
`@IsReset`	bit	no

Referenced objects

Schema	Object	Class
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBMDBQueueAgent	OBJECT_OR_COLUMN
dbo	QBM_FGISessionErrorRethrow	OBJECT_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_PDBQueueAgentInfoSet (@Ident_QBMDBQueueAgent nvarchar(128) , @IsReset bit = 0  ) as begin declare @spid int SET XACT_ABORT
2 OFF BEGIN TRY if @IsReset = 0 begin select @spid = @@spid end else begin select @spid = 0 end if not exists (select top 1 1 from QBMDBQueueAgent where
3 Ident_QBMDBQueueAgent = @Ident_QBMDBQueueAgent) begin insert into QBMDBQueueAgent (Ident_QBMDBQueueAgent, ServerProcess) values (@Ident_QBMDBQueueAgent
4, @spid) end else begin update QBMDBQueueAgent set ServerProcess = @spid where Ident_QBMDBQueueAgent = @Ident_QBMDBQueueAgent end END TRY BEGIN CATCH exec
5 QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende:
6  return end 
7

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:16:08.963

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; writes INSERT QBMDBQueueAgent, UPDATE QBMDBQueueAgent; reads/joins QBMDBQueueAgent

Declared parameters

Parameter	Type	Direction
`@Ident_QBMDBQueueAgent`	`nvarchar(128)`	input
`@IsReset`	`bit`	input

DML targets

INSERT QBMDBQueueAgent UPDATE QBMDBQueueAgent

Called routines

QBM_PSessionErrorAdd

Read/join references

QBMDBQueueAgent

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @Ident_QBMDBQueueAgent @IsReset @spid @Rethrow

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.

Referencing object	Relation	Evidence
dbo.QBM_PWorkDBQueueDelete	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PWorkHistoryDelete	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PWorkJobQueueDelete	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PWorkMaintenance	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PWorkSchedule	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PWorkDBQueueDelete	source text reference	uses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkHistoryDelete	source text reference	uses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkJobQueueDelete	source text reference	uses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkMaintenance	source text reference	uses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkSchedule	source text reference	inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling