dbo.QBM_PJobCreate_HOFireEvent
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
Interpretation
- Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
- Object-layer bridge detected through QBM_PJobCreate helper usage.
Relations
- References QBM_PJobCreate*
- References QBM_PJobCreate_HOFireEvent*
Typed Edges
- references source dbo.QBM_FGIJobCreateName source text reference
- references source dbo.QBM_PJobCreate source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
References
Referenced By
- dbo.QBM_FSQTriggerWatchXIsInEffect
- dbo.QBM_FSQTriggerWatchXOrigin
- dbo.ATT_PAfterMigrationTasks
- dbo.ATT_PAttestationHelperFill
- dbo.ATT_ZAttestationMakeDecisionEX
- dbo.ATT_ZAttestationReminder
- dbo.QBM_PF3416818676AABF8BABD3AB_
- dbo.QBM_PJobCreate_HOFireEvent_B
- dbo.QBM_PJobCreate_HOFireEvent_L
- dbo.QBM_PJobCreate_SendMail
- dbo.QBM_PJobCreate_SendRMail
- dbo.QBM_PJobQueueLoad
- dbo.QBM_PJobUpdateState_Bulk
- dbo.QBM_PMNTableInsert
- dbo.QBM_PMNTableInsertOwnPK
- dbo.QBM_PQBMServerHasJobService
- dbo.QBM_PScheduleStartJob
- dbo.QBM_ZDeferredOperationExecute
- dbo.QER_P04F128DC257D2B3C236MAIL_
- dbo.QER_PITShopProductNodeCheck
- dbo.QER_ZITShopCheckDecision
- dbo.QER_ZITShopMakeDecisionEX
- dbo.RPS_ZScheduleStart
- dbo.DPR_TDDPRSystemSyncDependency
- dbo.DPR_TIDPRSystemSyncDependency
- dbo.DPR_TUDialogColumn
- dbo.DPR_TUDialogTable
- dbo.DPR_TUDPRSystemSyncDependency
- dbo.QBM_TDQBMServerHasDeployTarget
- dbo.QBM_TIJobqueue
- dbo.QBM_TIQBMServerHasDeployTarget
- dbo.QER_TIPerson
Complete Source
1CREATE PROCEDURE QBM_PJobCreate_HOFireEvent(2 @objecttype nvarchar(255),3 @whereclause nvarchar(max),4 @EventName nvarchar(256),5 @GenProcID varchar(38),6 @ObjectKeysAffected QBM_YParameterList READONLY,7 @ConnectionVariables nvarchar(max) = NULL,8 @AuthenticationString nvarchar(max) = NULL,9 @SingleTransaction BIT = 1,10 @p2 nvarchar(1024) = N '',11 @v2 nvarchar(max) = N '',12 @p3 nvarchar(1024) = N '',13 @v3 nvarchar(max) = N '',14 @p4 nvarchar(1024) = N '',15 @v4 nvarchar(max) = N '',16 @p5 nvarchar(1024) = N '',17 @v5 nvarchar(max) = N '',18 @p6 nvarchar(1024) = N '',19 @v6 nvarchar(max) = N '',20 @p7 nvarchar(1024) = N '',21 @v7 nvarchar(max) = N '',22 @p8 nvarchar(1024) = N '',23 @v8 nvarchar(max) = N '',24 @p9 nvarchar(1024) = N '',25 @v9 nvarchar(max) = N '',26 @p10 nvarchar(1024) = N '',27 @v10 nvarchar(max) = N '',28 @p11 nvarchar(1024) = N '',29 @v11 nvarchar(max) = N '',30 @p12 nvarchar(1024) = N '',31 @v12 nvarchar(max) = N '',32 @p13 nvarchar(1024) = N '',33 @v13 nvarchar(max) = N '',34 @p14 nvarchar(1024) = N '',35 @v14 nvarchar(max) = N '',36 @p15 nvarchar(1024) = N '',37 @v15 nvarchar(max) = N '',38 @p16 nvarchar(1024) = N '',39 @v16 nvarchar(max) = N '',40 @p17 nvarchar(1024) = N '',41 @v17 nvarchar(max) = N '',42 @p18 nvarchar(1024) = N '',43 @v18 nvarchar(max) = N '',44 @p19 nvarchar(1024) = N '',45 @v19 nvarchar(max) = N '',46 @p20 nvarchar(1024) = N '',47 @v20 nvarchar(max) = N '',48 @p21 nvarchar(1024) = N '',49 @v21 nvarchar(max) = N '',50 @p22 nvarchar(1024) = N '',51 @v22 nvarchar(max) = N '',52 @p23 nvarchar(1024) = N '',53 @v23 nvarchar(max) = N '',54 @p24 nvarchar(1024) = N '',55 @v24 nvarchar(max) = N '',56 @p25 nvarchar(1024) = N '',57 @v25 nvarchar(max) = N '',58 @p26 nvarchar(1024) = N '',59 @v26 nvarchar(max) = N '',60 @p27 nvarchar(1024) = N '',61 @v27 nvarchar(max) = N '',62 @p28 nvarchar(1024) = N '',63 @v28 nvarchar(max) = N '',64 @p29 nvarchar(1024) = N '',65 @v29 nvarchar(max) = N '',66 @p30 nvarchar(1024) = N '',67 @v30 nvarchar(max) = N '',68 @p31 nvarchar(1024) = N '',69 @v31 nvarchar(max) = N '',70 @isToFreezeOnError BIT = 0,71 @Retries int = 0,72 @priority int = 5,73 @Jobchainname nvarchar(256) = NULL,74 @StartAt datetime = NULL,75 @BasisObjectKey varchar(138) = N '',76 @XUser nvarchar(64) = NULL,77 @WhereClauseAdditional nvarchar(max) = '',78 @checkForExisting BIT = 0,79 @QueueName nvarchar(256) = NULL80)81AS82BEGIN83 DECLARE @Parameters QBM_YParameterList84 DECLARE @JobChainNameAddOn nvarchar(256)85 SET XACT_ABORT OFF86 BEGIN TRY87 IF @Jobchainname IS NULL88 BEGIN89 SELECT90 @JobChainNameAddOn = ' fire event ' + @EventName + ' for object type ' + @objecttype91 SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)92 END93 INSERT INTO @Parameters(Parameter1,94 ContentFull)95 VALUES('objecttype',96 @objecttype),97 ('WhereClause',98 @whereclause),99 ('WhereClauseAdditional',100 @WhereClauseAdditional),101 ('EventName',102 @EventName),103 (@p2,104 @v2),105 (@p3,106 @v3),107 (@p4,108 @v4),109 (@p5,110 @v5),111 (@p6,112 @v6),113 (@p7,114 @v7),115 (@p8,116 @v8),117 (@p9,118 @v9),119 (@p10,120 @v10),121 (@p11,122 @v11),123 (@p12,124 @v12),125 (@p13,126 @v13),127 (@p14,128 @v14),129 (@p15,130 @v15),131 (@p16,132 @v16),133 (@p17,134 @v17),135 (@p18,136 @v18),137 (@p19,138 @v19),139 (@p20,140 @v20),141 (@p21,142 @v21),143 (@p22,144 @v22),145 (@p23,146 @v23),147 (@p24,148 @v24),149 (@p25,150 @v25),151 (@p26,152 @v26),153 (@p27,154 @v27),155 (@p28,156 @v28),157 (@p29,158 @v29),159 (@p30,160 @v30),161 (@p31,162 @v31)163 IF @ConnectionVariables > ' '164 BEGIN165 INSERT INTO @Parameters(Parameter1,166 ContentFull)167 VALUES('ConnectionVariables',168 @ConnectionVariables)169 END170 IF @AuthenticationString > ' '171 BEGIN172 INSERT INTO @Parameters(Parameter1,173 ContentFull)174 VALUES('AuthenticationString',175 @AuthenticationString)176 END177 IF @SingleTransaction = 0178 BEGIN179 INSERT INTO @Parameters(Parameter1,180 ContentFull)181 VALUES('SingleTransaction',182 'FALSE')183 END184 EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',185 'FireGenEvent',186 @Parameters,187 @GenProcID,188 @ObjectKeysAffected,189 @isToFreezeOnError,190 @Retries,191 @priority,192 @Jobchainname,193 @StartAt,194 @BasisObjectKey,195 @XUser,196 @QueueName,197 @checkForExisting198 END TRY199 BEGIN CATCH200 EXEC QBM_PSessionErrorAdd DEFAULT201 RAISERROR('',202 18,203 1)204 WITH NOWAIT205 END CATCH206 ende:207 RETURN208ENDOpen raw exported source
1 create procedure QBM_PJobCreate_HOFireEvent( @objecttype nvarchar(255), @whereclause nvarchar(max) , @EventName nvarchar(256) , @GenProcID2 varchar(38) , @ObjectKeysAffected QBM_YParameterList readOnly , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null3 , @SingleTransaction bit = 1 , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar (max) = N'' , @p4 nvarchar4 (1024) = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p6 nvarchar (1024) = N'', @v6 nvarchar (max) = N'' , @p75 nvarchar (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) = N'' , @p9 nvarchar (1024) = N'', @v9 nvarchar (max) 6= N'' , @p10 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 nvarchar (max) = N'' , @p12 nvarchar (1024) = N'', @v127 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max) = N'' , @p15 nvarchar (10248) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v17 nvarchar (max) = N'' , @p189 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (1024) = N'', @v20 nvarchar (max10) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p23 nvarchar (1024) = N'', @v2311 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max) = N'' , @p26 nvarchar (102412) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v28 nvarchar (max) = N'' , @p2913 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (1024) = N'', @v31 nvarchar (max14) = N'' , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey15 varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null16 ) as begin declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if @Jobchainname is null begin17 select @JobChainNameAddOn = ' fire event ' + @EventName + ' for object type ' + @objecttype select @Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn18) end insert into @Parameters (Parameter1, ContentFull) values ('objecttype', @objecttype) , ('WhereClause', @whereclause) , ('WhereClauseAdditional', 19@WhereClauseAdditional) , ( 'EventName' , @EventName ) , ( @p2 , @v2 ) , ( @p3 , @v3 ) , ( @p4 , @v4 ) , ( @p5 , @v5 ) , ( @p6 , @v6 ) , ( @p7 , @v7 )20 , ( @p8 , @v8 ) , ( @p9 , @v9 ) , ( @p10 , @v10 ) , ( @p11 , @v11 ) , ( @p12 , @v12 ) , ( @p13 , @v13 ) , ( @p14 , @v14 ) , ( @p15 , @v15 ) , ( @p16 ,21 @v16 ) , ( @p17 , @v17 ) , ( @p18 , @v18 ) , ( @p19 , @v19 ) , ( @p20 , @v20 ) , ( @p21 , @v21 ) , ( @p22 , @v22 ) , ( @p23 , @v23 ) , ( @p24 , @v24 )22 , ( @p25 , @v25 ) , ( @p26 , @v26 ) , ( @p27 , @v27 ) , ( @p28 , @v28 ) , ( @p29 , @v29 ) , ( @p30 , @v30 ) , ( @p31 , @v31 ) if @ConnectionVariables 23> ' ' begin insert into @Parameters(Parameter1, ContentFull) values ('ConnectionVariables', @ConnectionVariables) end if @AuthenticationString > ' ' begin24 insert into @Parameters(Parameter1, ContentFull) values ('AuthenticationString', @AuthenticationString) end if @SingleTransaction = 0 begin insert into25 @Parameters(Parameter1, ContentFull) values ('SingleTransaction', 'FALSE') end exec QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent'26 , 'FireGenEvent' , @Parameters , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey27 , @XUser , @QueueName , @checkForExisting END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return28 end 29