Back to OIM Explorer

dbo.QBM_ZJobHistoryShrink_Pat

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 356 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_PJobHistoryShrink source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTransactionLevelCheck source text reference
  • references source dbo.QBM_ZJobHistoryShrink source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL22 lines
1CREATE PROCEDURE QBM_ZJobHistoryShrink_Pat(2  @SlotNumber int,3  @KeyPattern varchar(38),4  @dummy2 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  BEGIN TRY10    EXEC QBM_PTransactionLevelCheck 0,11      @@procid12    EXEC QBM_PJobHistoryShrink @KeyPattern13  END TRY14  BEGIN CATCH15    EXEC QBM_PSessionErrorAdd DEFAULT16    RAISERROR('',17    18,18    1)19      WITH NOWAIT20  END CATCH21  RETURN22END
Open raw exported source
SQL ยท Raw4 lines
1 create   procedure QBM_ZJobHistoryShrink_Pat ( @SlotNumber int , @KeyPattern varchar(38) , @dummy2 varchar(38) , @GenProcID varchar(38) ) as begin2 BEGIN TRY exec QBM_PTransactionLevelCheck 0, @@procid exec QBM_PJobHistoryShrink @KeyPattern END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR3 ('', 18, 1) WITH NOWAIT END CATCH return end 4