Back to OIM Explorer

dbo.QBM_PDBQueueExternalTaskFire

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 695 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_FGISessionErrorRethrow 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

SQL37 lines
1CREATE PROCEDURE QBM_PDBQueueExternalTaskFire(2  @uid_Task varchar(38),3  @CleanCutOffTask BIT = 14)5AS6BEGIN7  DECLARE @Debuglevel char(1) = 'W'8  SET XACT_ABORT OFF9  BEGIN TRY10    IF EXISTS(11      SELECT TOP 1 112      FROM DialogDatabase d13      WHERE14        d.UID_CutOffTask = @uid_Task AND d.IsMainDatabase = 1)15    BEGIN16      UPDATE DialogDatabase17      SET UID_CutOffTask = NULL18      WHERE19        IsMainDatabase = 1 AND @CleanCutOffTask = 120      DELETE DialogDBQueue21      WHERE22        UID_Task = @uid_Task23      EXEC QBM_PSessionContextSet 'INSERTEDINTODBQUEUE',24      '1'25    END26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()30    RAISERROR(@Rethrow,31    18,32    1)33      WITH NOWAIT34  END CATCH35  ende:36  RETURN37END
Open raw exported source
SQL ยท Raw6 lines
1  create   procedure QBM_PDBQueueExternalTaskFire (@uid_Task varchar(38) , @CleanCutOffTask bit = 1 ) AS begin declare @Debuglevel char(1) = 'W'2 SET XACT_ABORT OFF BEGIN TRY if exists (select top 1 1 from DialogDatabase d where d.UID_CutOffTask = @uid_Task and d.IsMainDatabase = 1 ) begin update3 DialogDatabase set UID_CutOffTask = null where IsMainDatabase = 1  and @CleanCutOffTask = 1  delete DialogDBQueue where UID_Task = @uid_Task exec QBM_PSessionContextSet4 'INSERTEDINTODBQUEUE', '1' end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()5 RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende:  return end 6