Back to OIM Explorer

dbo.QBM_PDBQCS_WaitJobReset

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 423 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_PJournal source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL25 lines
1CREATE PROCEDURE QBM_PDBQCS_WaitJobReset(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @Debugstarttime datetime = getUtcdate()7  DECLARE @Debuglevel char(1) = 'I'8  BEGIN TRY9    EXEC QBM_PSessionContextSet 'INSERTEDINTODBQUEUE',10    '1'11  END TRY12  BEGIN CATCH13    EXEC QBM_PSessionErrorAdd DEFAULT14    RAISERROR('',15    18,16    1)17      WITH NOWAIT18  END CATCH19  ende:20  EXEC QBM_PJournal @Debugstarttime,21    @@procid,22  'T',23    @Debuglevel24  RETURN25END
Open raw exported source
SQL ยท Raw4 lines
1   create   procedure QBM_PDBQCS_WaitJobReset ( @SlotNumber int ) as begin  declare @Debugstarttime datetime = getUtcdate() declare @Debuglevel 2char(1) = 'I' BEGIN TRY exec QBM_PSessionContextSet 'INSERTEDINTODBQUEUE', '1'                  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR3 ('', 18, 1) WITH NOWAIT END CATCH ende: exec QBM_PJournal @Debugstarttime, @@procid, 'T', @Debuglevel return end 4