Back to OIM Explorer

dbo.QBM_PJobCreate_HOTemplate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 2.089 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_HOTemplate(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),4  @Columns nvarchar(max),5  @GenProcID varchar(38),6  @ObjectKeysAffected QBM_YParameterList READONLY,7  @ConnectionVariables nvarchar(max) = NULL,8  @AuthenticationString nvarchar(max) = NULL,9  @SingleTransaction BIT = 1,10  @isToFreezeOnError BIT = 0,11  @Retries int = 0,12  @priority int = 5,13  @Jobchainname nvarchar(256) = NULL,14  @StartAt datetime = NULL,15  @BasisObjectKey varchar(138) = N '',16  @XUser nvarchar(64) = NULL,17  @WhereClauseAdditional nvarchar(max) = '',18  @checkForExisting BIT = 0,19  @QueueName nvarchar(256) = NULL20)21AS22BEGIN23  DECLARE @Parameters QBM_YParameterList24  DECLARE @JobChainNameAddOn nvarchar(256)25  SET XACT_ABORT OFF26  BEGIN TRY27    IF @Jobchainname IS NULL28    BEGIN29      SELECT @JobChainNameAddOn = ' execute template for object type ' + @objecttype30      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)31    END32    IF ISNULL(@Columns,33    '') = ''34    BEGIN35      SELECT @Columns = '*'36    END37    INSERT INTO @Parameters(Parameter1,38    ContentFull)39    VALUES('objecttype',40    @objecttype),41    ('WhereClause',42    @whereclause),43    ('WhereClauseAdditional',44    @WhereClauseAdditional),45    ('Columns',46    @Columns)47    IF @ConnectionVariables > ' '48    BEGIN49      INSERT INTO @Parameters(Parameter1,50      ContentFull)51      VALUES('ConnectionVariables',52      @ConnectionVariables)53    END54    IF @AuthenticationString > ' '55    BEGIN56      INSERT INTO @Parameters(Parameter1,57      ContentFull)58      VALUES('AuthenticationString',59      @AuthenticationString)60    END61    IF @SingleTransaction = 062    BEGIN63      INSERT INTO @Parameters(Parameter1,64      ContentFull)65      VALUES('SingleTransaction',66      'FALSE')67    END68    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',69    'EXECUTETEMPLATES',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_HOTemplate ( @objecttype nvarchar(255),  @whereclause nvarchar(max)  , @Columns nvarchar(max)   , @GenProcID 2varchar(38) , @ObjectKeysAffected QBM_YParameterList readOnly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null3 , @SingleTransaction bit = 1  , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime4 = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName5 nvarchar(256) = null ) as begin declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if @Jobchainname6 is null begin select @JobChainNameAddOn = ' execute template for object type ' + @objecttype select @Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn7) end if ISNULL(@Columns, '') = '' begin select @Columns = '*' end insert into @Parameters (Parameter1, ContentFull) values ('objecttype', @objecttype)8 , ('WhereClause', @whereclause) , ('WhereClauseAdditional', @WhereClauseAdditional)  , ( 'Columns' , @Columns ) if @ConnectionVariables > ' ' begin insert9 into @Parameters(Parameter1, ContentFull) values ('ConnectionVariables', @ConnectionVariables) end if @AuthenticationString > ' ' begin insert into @Parameters10(Parameter1, ContentFull) values ('AuthenticationString', @AuthenticationString) end if @SingleTransaction = 0 begin insert into @Parameters(Parameter111, ContentFull) values ('SingleTransaction', 'FALSE') end exec QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'EXECUTETEMPLATES' ,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