Back to OIM Explorer

dbo.QBM_PDBQueueActivityEnable

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 532 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_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL25 lines
1CREATE PROCEDURE QBM_PDBQueueActivityEnable2AS3BEGIN4  DECLARE @XUser nvarchar(64) = object_name(@@procid)5  DECLARE @Xdate datetime = getutcdate()6  SET XACT_ABORT OFF7  BEGIN TRY8    UPDATE DialogDatabase9    SET IsDBSchedulerDisabled = 0,10    XDateUpdated = @Xdate,11    XUserUpdated = @XUser12    WHERE13      IsMainDatabase = 1 AND IsDBSchedulerDisabled = 114  END TRY15  BEGIN CATCH16    EXEC QBM_PSessionErrorAdd DEFAULT17    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()18    RAISERROR(@Rethrow,19    18,20    1)21      WITH NOWAIT22  END CATCH23  endLabel:24  RETURN25END
Open raw exported source
SQL ยท Raw5 lines
1   create   procedure QBM_PDBQueueActivityEnable as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate2() SET XACT_ABORT OFF BEGIN TRY update DialogDatabase set IsDBSchedulerDisabled = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser where IsMainDatabase3 = 1 and IsDBSchedulerDisabled = 1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow4() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 5