Back to OIM Explorer

dbo.QBM_PJobCreate_SQLProc

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 1.697 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

  • No direct source references extracted.

Complete Source

SQL66 lines
1CREATE PROCEDURE QBM_PJobCreate_SQLProc(2  @ProcedureName varchar(30),3  @WithoutTransaction varchar(20),4  @GenProcID varchar(38),5  @isToFreezeOnError BIT = 0,6  @Retries int = 0,7  @priority int = 5,8  @Jobchainname nvarchar(256) = NULL,9  @StartAt datetime = NULL,10  @BasisObjectKey varchar(138) = N '',11  @XUser nvarchar(64) = NULL,12  @WhereClauseAdditional nvarchar(max) = '',13  @checkForExisting BIT = 0,14  @QueueName nvarchar(256) = NULL15)16AS17BEGIN18  DECLARE @SQLCmd nvarchar(max)19  DECLARE @ObjectKeysAffected QBM_YParameterList20  DECLARE @Parameters QBM_YParameterList21  DECLARE @JobChainNameAddOn nvarchar(256)22  SET XACT_ABORT OFF23  BEGIN TRY24    IF @Jobchainname IS NULL25    BEGIN26      SELECT @JobChainNameAddOn = ' call procedure ' + @ProcedureName27      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)28    END29    IF isnull(@WithoutTransaction,30    '') = ''31    BEGIN32      SELECT @WithoutTransaction = 'True'33    END34    SELECT @sqlcmd = N 'exec  ' + @ProcedureName35    INSERT INTO @Parameters(Parameter1,36    ContentFull)37    VALUES('SQLStmt',38    @sqlcmd),39    ('WithoutTransaction',40    @WithoutTransaction)41    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.SQLComponent',42    'Execute SQL',43      @Parameters = @Parameters,44      @GenProcID = @GenProcID,45      @ObjectKeysAffected = DEFAULT,46      @isToFreezeOnError = @isToFreezeOnError,47      @Retries = @Retries,48      @priority = @priority,49      @Jobchainname = @Jobchainname,50      @StartAt = @StartAt,51      @BasisObjectKey = @BasisObjectKey,52      @XUser = @XUser,53      @QueueName = @QueueName,54      @checkForExisting = @checkForExisting55  END TRY56  BEGIN CATCH57    EXEC QBM_PSessionErrorAdd DEFAULT58    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()59    RAISERROR(@Rethrow,60    18,61    1)62      WITH NOWAIT63  END CATCH64  ende:65  RETURN66END
Open raw exported source
SQL ยท Raw12 lines
1  create   procedure QBM_PJobCreate_SQLProc (@ProcedureName varchar (30) , @WithoutTransaction varchar(20)  , @GenProcID varchar(38) , @isToFreezeOnError2 bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , 3@XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = ''  , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin  declare4 @SQLCmd nvarchar(max)  declare @ObjectKeysAffected QBM_YParameterList declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) 5SET XACT_ABORT OFF BEGIN TRY if @Jobchainname is null begin select @JobChainNameAddOn = ' call procedure ' + @ProcedureName select @Jobchainname =dbo.QBM_FGIJobCreateName6 ( @JobChainNameAddOn) end if isnull(@WithoutTransaction, '') = '' begin select @WithoutTransaction = 'True' end select @sqlcmd = N'exec  ' + @ProcedureName7  insert into @Parameters (Parameter1, ContentFull) values ('SQLStmt', @sqlcmd) , ('WithoutTransaction', @WithoutTransaction) exec QBM_PJobCreate 'VI.JobService.JobComponents.SQLComponent'8 , 'Execute SQL' , @Parameters = @Parameters , @GenProcID = @GenProcID , @ObjectKeysAffected = default , @isToFreezeOnError = @isToFreezeOnError , @Retries9 = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser , @QueueName10 = @QueueName , @checkForExisting = @checkForExisting  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow11() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 12