dbo.QBM_PJobCreate_HOFireEvent_L

SQL_STORED_PROCEDURE

Created 2025-06-27T18:00:59.963 · modified 2026-04-14T23:20:31.400 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@objecttypenvarcharno
@XObjectKeysQBM_YParameterListno
@EventNamenvarcharno
@GenProcIDvarcharno
@AdditionalObjectKeysAffectedQBM_YParameterListno
@ConnectionVariablesnvarcharno
@AuthenticationStringnvarcharno
@SingleTransactionbitno
@p2nvarcharno
@v2nvarcharno
@p3nvarcharno
@v3nvarcharno
@p4nvarcharno
@v4nvarcharno
@p5nvarcharno
@v5nvarcharno
@p6nvarcharno
@v6nvarcharno
@p7nvarcharno
@v7nvarcharno
@p8nvarcharno
@v8nvarcharno
@p9nvarcharno
@v9nvarcharno
@p10nvarcharno
@v10nvarcharno
@p11nvarcharno
@v11nvarcharno
@p12nvarcharno
@v12nvarcharno
@p13nvarcharno
@v13nvarcharno
@p14nvarcharno
@v14nvarcharno
@p15nvarcharno
@v15nvarcharno
@p16nvarcharno
@v16nvarcharno
@p17nvarcharno
@v17nvarcharno
@p18nvarcharno
@v18nvarcharno
@p19nvarcharno
@v19nvarcharno
@p20nvarcharno
@v20nvarcharno
@p21nvarcharno
@v21nvarcharno
@p22nvarcharno
@v22nvarcharno
@p23nvarcharno
@v23nvarcharno
@p24nvarcharno
@v24nvarcharno
@p25nvarcharno
@v25nvarcharno
@p26nvarcharno
@v26nvarcharno
@p27nvarcharno
@v27nvarcharno
@p28nvarcharno
@v28nvarcharno
@p29nvarcharno
@v29nvarcharno
@p30nvarcharno
@v30nvarcharno
@p31nvarcharno
@v31nvarcharno
@isToFreezeOnErrorbitno
@Retriesintno
@priorityintno
@Jobchainnamenvarcharno
@StartAtdatetimeno
@BasisObjectKeyvarcharno
@XUsernvarcharno
@WhereClauseAdditionalnvarcharno
@checkForExistingbitno
@QueueNamenvarcharno

Referenced objects

SchemaObjectColumn/minorClass
QBM_PF3416818676AABF8BABD3AB_OBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_YObjectKeyAndPortionTYPE
QBM_YParameterListTYPE
dboQBM_FGISessionErrorRethrowOBJECT_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_PJobCreate_HOFireEvent_L( @objecttype nvarchar(255),  @XObjectKeys QBM_YParameterList readonly,  @EventName nvarchar(256
2),  @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly     , @ConnectionVariables nvarchar(max) = null , @AuthenticationString
3 nvarchar(max) = null , @SingleTransaction bit = 1 , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar (max
4) = N'' , @p4 nvarchar (1024) = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p6 nvarchar (1024) = N'', @v6 nvarchar
5 (max) = N'' , @p7 nvarchar (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) = N'' , @p9 nvarchar (1024) = N'', @v9
6 nvarchar (max) = N'' , @p10 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 nvarchar (max) = N'' , @p12 nvarchar (1024
7) = N'', @v12 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max) = N'' , @p15
8 nvarchar (1024) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v17 nvarchar (max
9) = N'' , @p18 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (1024) = N'', @v20
10 nvarchar (max) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p23 nvarchar (1024
11) = N'', @v23 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max) = N'' , @p26
12 nvarchar (1024) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v28 nvarchar (max
13) = N'' , @p29 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (1024) = N'', @v31
14 nvarchar (max) = N'' , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null
15 , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName
16 nvarchar(256) = null ) as begin declare @Portion int declare @PortionMax int declare @ElementsMax int declare @ElementsLen int declare @AllObjectKeysIn
17 QBM_YObjectKeyAndPortion SET XACT_ABORT OFF BEGIN TRY select top 1 @ElementsLen = len(Parameter1) from @XObjectKeys if isnull(@ElementsLen, 0) = 0 begin
18 goto endLabel end select @ElementsMax = 20000 / @ElementsLen if @ElementsMax > 450 begin select @ElementsMax = 450 end insert into @AllObjectKeysIn (ObjectKey
19, Portion) select o.Parameter1 , ((ROW_NUMBER() over( order by o.Parameter1) ) / @ElementsMax) + 1 from @XObjectKeys o select @PortionMax = max(i.Portion
20) , @Portion = 1 from @AllObjectKeysIn i while @Portion <= @PortionMax begin exec QBM_PF3416818676AABF8BABD3AB_ @Portion = @Portion , @AllObjectKeysIn 
21= @AllObjectKeysIn , @objecttype = @objecttype , @EventName = @EventName , @GenProcID = @GenProcID , @AdditionalObjectKeysAffected = @AdditionalObjectKeysAffected
22 , @ConnectionVariables = @ConnectionVariables , @AuthenticationString = @AuthenticationString , @SingleTransaction = @SingleTransaction , @p2 = @p2 , 
23@v2 = @v2, @p3 = @p3, @v3 = @v3, @p4 = @p4, @v4 = @v4, @p5 = @p5, @v5 = @v5, @p6 = @p6, @v6 = @v6, @p7 = @p7, @v7 = @v7, @p8 = @p8, @v8 = @v8, @p9 = @p9
24, @v9 = @v9, @p10 = @p10, @v10 = @v10, @p11 = @p11, @v11 = @v11, @p12 = @p12, @v12 = @v12, @p13 = @p13, @v13 = @v13, @p14 = @p14, @v14 = @v14, @p15 = @p15
25, @v15 = @v15, @p16 = @p16, @v16 = @v16, @p17 = @p17, @v17 = @v17, @p18 = @p18, @v18 = @v18, @p19 = @p19, @v19 = @v19, @p20 = @p20, @v20 = @v20, @p21 =
26 @p21, @v21 = @v21, @p22 = @p22, @v22 = @v22, @p23 = @p23, @v23 = @v23, @p24 = @p24, @v24 = @v24, @p25 = @p25, @v25 = @v25, @p26 = @p26, @v26 = @v26, @p27
27 = @p27, @v27 = @v27, @p28 = @p28, @v28 = @v28, @p29 = @p29, @v29 = @v29, @p30 = @p30, @v30 = @v30, @p31 = @p31, @v31 = @v31 , @isToFreezeOnError = @isToFreezeOnError
28 , @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser
29 , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName select @Portion += 1 end END TRY BEGIN
30 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 
31CATCH endLabel: return end 
32

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:31.400

creates object-layer jobs via QBM_PJobCreate* fires object-layer event via HOFireEvent has TRY/CATCH error handling

Summary: calls QBM_PF3416818676AABF8BABD3AB_, QBM_PSessionErrorAdd; writes INSERT into

Declared parameters

ParameterTypeDirection
@objecttypenvarchar(255)input
@XObjectKeysqbm_yparameterlistinput
@EventNamenvarchar(256)input
@GenProcIDvarchar(38)input
@AdditionalObjectKeysAffectedqbm_yparameterlistinput
@ConnectionVariablesnvarcharinput
@AuthenticationStringnvarcharinput
@SingleTransactionbitinput
@p2nvarchar(1024)input
@v2nvarcharinput
@p3nvarchar(1024)input
@v3nvarcharinput
@p4nvarchar(1024)input
@v4nvarcharinput
@p5nvarchar(1024)input
@v5nvarcharinput
@p6nvarchar(1024)input
@v6nvarcharinput
@p7nvarchar(1024)input
@v7nvarcharinput
@p8nvarchar(1024)input
@v8nvarcharinput
@p9nvarchar(1024)input
@v9nvarcharinput
@p10nvarchar(1024)input
@v10nvarcharinput
@p11nvarchar(1024)input
@v11nvarcharinput
@p12nvarchar(1024)input
@v12nvarcharinput
@p13nvarchar(1024)input
@v13nvarcharinput
@p14nvarchar(1024)input
@v14nvarcharinput
@p15nvarchar(1024)input
@v15nvarcharinput
@p16nvarchar(1024)input
@v16nvarcharinput
@p17nvarchar(1024)input
@v17nvarcharinput
@p18nvarchar(1024)input
@v18nvarcharinput
@p19nvarchar(1024)input
@v19nvarcharinput
@p20nvarchar(1024)input
@v20nvarcharinput
@p21nvarchar(1024)input
@v21nvarcharinput
@p22nvarchar(1024)input
@v22nvarcharinput
@p23nvarchar(1024)input
@v23nvarcharinput
@p24nvarchar(1024)input
@v24nvarcharinput
@p25nvarchar(1024)input
@v25nvarcharinput
@p26nvarchar(1024)input
@v26nvarcharinput
@p27nvarchar(1024)input
@v27nvarcharinput
@p28nvarchar(1024)input
@v28nvarcharinput
@p29nvarchar(1024)input
@v29nvarcharinput
@p30nvarchar(1024)input
@v30nvarcharinput
@p31nvarchar(1024)input
@v31nvarcharinput
@isToFreezeOnErrorbitinput
@Retriesintinput
@priorityintinput
@Jobchainnamenvarchar(256)input
@StartAtdatetimeinput
@BasisObjectKeyvarchar(138)input
@XUsernvarchar(64)input
@WhereClauseAdditionalnvarcharinput
@checkForExistingbitinput
@QueueNamenvarchar(256)input

DML targets

INSERT into

Called routines

Read/join references

None extracted.

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @objecttype @XObjectKeys @EventName @GenProcID @AdditionalObjectKeysAffected @ConnectionVariables @AuthenticationString @SingleTransaction @p2 @v2 @p3 @v3 @p4 @v4 @p5 @v5 @p6 @v6 @p7 @v7 @p8 @v8 @p9 @v9 @p10 @v10 @p11 @v11 @p12 @v12 @p13 @v13 @p14 @v14 @p15 @v15 @p16 @v16 @p17 @v17

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 objectRelationEvidence
dbo.QBM_PJobCreate_HOFireEvent_BSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_P04F128DC257D2B3C236MAIL_SQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopCheckDecisionSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T502565353D4716D18CD190BF8SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T50FDADCCF5FF5953D3C5CDE3FSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T52819732AD9162A7E270A272ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5353FF58B0B2681FBC37AB5BESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5520BD220624D98637D86D5E3SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T55870560D013ECC8B97535914SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5665D8E7E130F13C8F0E23EF7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T56F3B6D6D79DDA47EF70C2DB2SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T577565B77F38638D05A8B603CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T586345931225D1263A0DC4DB5SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T58E3A2887B8C428A1803E054ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5DEC3B8B413163D8D6070A959SQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_TDQBMServerHasDeployTargetSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_TIQBMServerHasDeployTargetSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TIPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_FSQTriggerWatchXIsInEffectsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent
dbo.QBM_FSQTriggerWatchXOriginsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent
dbo.QBM_PJobCreate_HOFireEvent_Bsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, has TRY/CATCH error handling
dbo.QBM_PMNTableInsertsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_PMNTableInsertOwnPKsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QER_P04F128DC257D2B3C236MAIL_source text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values
dbo.QER_PITShopProductNodeChecksource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QER_ZITShopCheckDecisionsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_TDQBMServerHasDeployTargetsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_TIQBMServerHasDeployTargetsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QER_TIPersonsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling