Back to OIM Explorer

dbo.QBM_ZQBMSessionStoreShrink

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 603 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_FCVStringToInt source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL31 lines
1CREATE PROCEDURE QBM_ZQBMSessionStoreShrink(2  @SlotnumberDummy int,3  @Dummy1 varchar(38),4  @Dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  DECLARE @QBMSessionStoreLifetime int10  BEGIN TRY11    SELECT12      TOP 1 @QBMSessionStoreLifetime = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('QBM\AppServer\SessionTimeout'),13      0)14    IF @QBMSessionStoreLifetime > 015    BEGIN16      DELETE QBMSessionStore17      FROM QBMSessionStore u18      WHERE19        datediff(hh,20      u.XDateUpdated,21      getutcdate()) > @QBMSessionStoreLifetime22    END23  END TRY24  BEGIN CATCH25    EXEC QBM_PSessionErrorAdd DEFAULT26    RAISERROR('',27    18,28    1)29      WITH NOWAIT30  END CATCH31END
Open raw exported source
SQL ยท Raw5 lines
1  create   procedure QBM_ZQBMSessionStoreShrink ( @SlotnumberDummy int , @Dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcIDDummy varchar(38)2 ) AS begin declare @QBMSessionStoreLifetime int BEGIN TRY select top 1 @QBMSessionStoreLifetime = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('QBM\AppServer\SessionTimeout'3), 0) if @QBMSessionStoreLifetime > 0 begin delete QBMSessionStore from QBMSessionStore u where datediff(hh, u.XDateUpdated, getutcdate()) > @QBMSessionStoreLifetime4 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 5