Back to OIM Explorer

dbo.QBM_PJobCreate_Mnt

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 1.036 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_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PWorkMaintenance source text reference

References

Referenced By

Complete Source

SQL45 lines
1CREATE PROCEDURE QBM_PJobCreate_Mnt(2  @SQLCmd nvarchar(max),3  @GenProcID varchar(38)4)5AS6BEGIN7  DECLARE @Parameters QBM_YParameterList8  DECLARE @ComponentClass nvarchar(256) = 'VI.JobService.JobComponents.SQLComponent'9  DECLARE @TaskName nvarchar(64) = 'Execute SQL'10  DECLARE @QueueName nvarchar(128) = 'QBM_PWorkMaintenance'11  SET XACT_ABORT OFF12  BEGIN TRY13    INSERT INTO @Parameters(Parameter1,14    ContentFull)15    VALUES('SQLStmt',16    @sqlcmd),17    ('WithoutTransaction',18    '1')19    IF NOT EXISTS(20      SELECT TOP 1 121      FROM JobQueue q22      WITH(readpast)23    WHERE24      q.ComponentClass = @ComponentClass AND q.TaskName = @TaskName AND q.Queue = @QueueName AND q.ParamIN LIKE CONCAT('%',25    replace(@SQLCmd, '''', ''''''), '%'))26    BEGIN27      EXEC QBM_PJobCreate @ComponentClass,28        @TaskName,29        @Parameters,30        @GenProcID,31        @ObjectKeysAffected = DEFAULT,32        @QueueName = @QueueName33    END34  END TRY35  BEGIN CATCH36    EXEC QBM_PSessionErrorAdd DEFAULT37    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()38    RAISERROR(@Rethrow,39    18,40    1)41      WITH NOWAIT42  END CATCH43  ende:44  RETURN45END
Open raw exported source
SQL ยท Raw8 lines
1   create   procedure QBM_PJobCreate_Mnt (@SQLCmd nvarchar(max) , @GenProcID varchar(38) )  as begin declare @Parameters QBM_YParameterList declare2 @ComponentClass nvarchar(256) = 'VI.JobService.JobComponents.SQLComponent' declare @TaskName nvarchar(64) = 'Execute SQL' declare @QueueName nvarchar(1283) = 'QBM_PWorkMaintenance' SET XACT_ABORT OFF BEGIN TRY insert into @Parameters (Parameter1, ContentFull) values ('SQLStmt', @sqlcmd) , ('WithoutTransaction'4, '1')  if not exists (select top 1 1 from JobQueue q with (readpast) where q.ComponentClass = @ComponentClass and q.TaskName = @TaskName and q.Queue =5 @QueueName and q.ParamIN like CONCAT('%', replace(@SQLCmd, '''', ''''''), '%')  ) begin exec QBM_PJobCreate @ComponentClass , @TaskName , @Parameters 6, @GenProcID , @ObjectKeysAffected = default , @QueueName = @QueueName end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar7(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 8