Back to OIM Explorer

dbo.QBM_ZJobHistoryShrink

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QBM-K-CommonShrinkJobHistory-Pat / QBM_ZJobHistoryShrink_Pat at line 4; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 664 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> QBM-K-CommonShrinkJobHistory-Pat / QBM_ZJobHistoryShrink_Pat at line 4
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZJobHistoryShrink_Pat at line 4 Bulk DBQueue insert -> QBM-K-CommonShrinkJobHistory-Pat / QBM_ZJobHistoryShrink_Pat at line 4
  • references source dbo.QBM_FTHexPattern source text reference
  • references source dbo.QBM_FGITableCountAll source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonShrinkJobHistory-Pat -> QBM_ZJobHistoryShrink_Pat QBM_PDBQueueInsert_Bulk 'QBM-K-CommonShrinkJobHistory-Pat', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end

References

Referenced By

Complete Source

SQL35 lines
1CREATE PROCEDURE QBM_ZJobHistoryShrink(2  @SlotNumber int,3  @dummy1 varchar(38) = '',4  @dummy2 varchar(38) = '',5  @GenProcID varchar(38) = ''6)7AS8BEGIN9  DECLARE @HexDigit int = 210  BEGIN TRY11    IF dbo.QBM_FGITableCountAll('jobhistory') > 60000012    BEGIN13      SELECT @HexDigit = 314    END15    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw16    INSERT INTO @DBQueueElements_01(Object,17    SubObject,18    GenProcID)19    SELECT20      h.HexPattern,21      '',22      @GenProcID23    FROM dbo.QBM_FTHexPattern(@HexDigit) h24    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonShrinkJobHistory-Pat',25      @DBQueueElements_0126  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    RAISERROR('',30    18,31    1)32      WITH NOWAIT33  END CATCH34  RETURN35END
Open raw exported source
SQL ยท Raw6 lines
1       create   procedure QBM_ZJobHistoryShrink ( @SlotNumber int , @dummy1 varchar(38) = '' , @dummy2 varchar(38)= '' , @GenProcID varchar(38)=2 '' ) as begin declare @HexDigit int = 2 BEGIN TRY if dbo.QBM_FGITableCountAll('jobhistory') > 600000 begin select @HexDigit = 3 end declare @DBQueueElements_013 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select h.HexPattern, '' , @GenProcID from dbo.QBM_FTHexPattern(@HexDigit4) h  exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonShrinkJobHistory-Pat', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR5 ('', 18, 1) WITH NOWAIT END CATCH return end 6