Back to OIM Explorer

dbo.QBM_PJobCreate_HODelete

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 2.090 characters

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*

Typed Edges

  • references source dbo.QBM_FGIJobCreateName source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL93 lines
1CREATE PROCEDURE QBM_PJobCreate_HODelete(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),4  @GenProcID varchar(38),5  @ObjectKeysAffected QBM_YParameterList READONLY,6  @ConnectionVariables nvarchar(max) = NULL,7  @AuthenticationString nvarchar(max) = NULL,8  @SingleTransaction BIT = 1,9  @isToFreezeOnError BIT = 0,10  @Retries int = 0,11  @priority int = 5,12  @Jobchainname nvarchar(256) = NULL,13  @StartAt datetime = NULL,14  @BasisObjectKey varchar(138) = '',15  @XUser nvarchar(64) = NULL,16  @WhereClauseAdditional nvarchar(max) = '',17  @checkForExisting BIT = 0,18  @QueueName nvarchar(256) = NULL,19  @DeepDelete BIT = 020)21AS22BEGIN23  DECLARE @Parameters QBM_YParameterList24  DECLARE @JobChainNameAddOn nvarchar(256)25  SET XACT_ABORT OFF26  BEGIN TRY27    IF @Jobchainname IS NULL28    BEGIN29      SELECT @JobChainNameAddOn = ' handle object delete for object type ' + @objecttype30      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)31    END32    INSERT INTO @Parameters(Parameter1,33    ContentFull)34    VALUES('objecttype',35    @objecttype),36    ('WhereClause',37    @whereclause),38    ('WhereClauseAdditional',39    @WhereClauseAdditional)40    IF @ConnectionVariables > ' '41    BEGIN42      INSERT INTO @Parameters(Parameter1,43      ContentFull)44      VALUES('ConnectionVariables',45      @ConnectionVariables)46    END47    IF @AuthenticationString > ' '48    BEGIN49      INSERT INTO @Parameters(Parameter1,50      ContentFull)51      VALUES('AuthenticationString',52      @AuthenticationString)53    END54    IF @SingleTransaction = 055    BEGIN56      INSERT INTO @Parameters(Parameter1,57      ContentFull)58      VALUES('SingleTransaction',59      'FALSE')60    END61    IF @DeepDelete = 162    BEGIN63      INSERT INTO @Parameters(Parameter1,64      ContentFull)65      VALUES('Deep',66      'TRUE')67    END68    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',69    'Delete',70      @Parameters,71      @GenProcID,72      @ObjectKeysAffected,73      @isToFreezeOnError,74      @Retries,75      @priority,76      @Jobchainname,77      @StartAt,78      @BasisObjectKey,79      @XUser,80      @QueueName,81      @checkForExisting82  END TRY83  BEGIN CATCH84    EXEC QBM_PSessionErrorAdd DEFAULT85    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()86    RAISERROR(@Rethrow,87    18,88    1)89      WITH NOWAIT90  END CATCH91  ende:92  RETURN93END
Open raw exported source
SQL ยท Raw15 lines
1 create   procedure QBM_PJobCreate_HODelete ( @objecttype nvarchar(255),  @whereclause nvarchar(max)  , @GenProcID varchar(38) , @ObjectKeysAffected2 QBM_YParameterList readOnly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1  , 3@isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar4(138) = '' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null , @DeepDelete5 bit = 0  ) as begin declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if @Jobchainname is null6 begin select @JobChainNameAddOn = ' handle object delete for object type ' + @objecttype select @Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn7) end insert into @Parameters (Parameter1, ContentFull) values ('objecttype', @objecttype) , ('WhereClause', @whereclause) , ('WhereClauseAdditional', 8@WhereClauseAdditional)  if @ConnectionVariables > ' ' begin insert into @Parameters(Parameter1, ContentFull) values ('ConnectionVariables', @ConnectionVariables9) end if @AuthenticationString > ' ' begin insert into @Parameters(Parameter1, ContentFull) values ('AuthenticationString', @AuthenticationString) end 10if @SingleTransaction = 0 begin insert into @Parameters(Parameter1, ContentFull) values ('SingleTransaction', 'FALSE') end if @DeepDelete = 1 begin insert11 into @Parameters(Parameter1, ContentFull) values ('Deep', 'TRUE') end exec QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'Delete'12 , @Parameters , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @QueueName13 , @checkForExisting END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR 14(@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 15