Back to OIM Explorer

dbo.QBM_PJobUpdateState

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 591 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_PJobUpdateState_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL31 lines
1CREATE PROCEDURE QBM_PJobUpdateState(2  @uid_job varchar(38),3  @newState nvarchar(32),4  @SuccesInfo int,5  @MessageString nvarchar(max) = N ''6)7AS8BEGIN9  DECLARE @JobsToChange QBM_YJobStateInfo10  SET XACT_ABORT OFF11  BEGIN TRY12    INSERT INTO @JobsToChange(UID_Job,13    NewState,14    SuccesInfo,15    MessageString)16    VALUES(@UID_Job,17    @NewState,18    @SuccesInfo,19    @MessageString)20    EXEC QBM_PJobUpdateState_Bulk @JobsToChange21  END TRY22  BEGIN CATCH23    EXEC QBM_PSessionErrorAdd DEFAULT24    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()25    RAISERROR(@Rethrow,26    18,27    1)28      WITH NOWAIT29  END CATCH30  RETURN31END
Open raw exported source
SQL ยท Raw5 lines
1    create   procedure QBM_PJobUpdateState (@uid_job varchar(38) ,  @newState nvarchar(32),  @SuccesInfo int,   @MessageString nvarchar(max) = N''2  ) as begin declare @JobsToChange QBM_YJobStateInfo SET XACT_ABORT OFF BEGIN TRY insert into @JobsToChange(UID_Job, NewState, SuccesInfo, MessageString3) values (@UID_Job, @NewState, @SuccesInfo, @MessageString) exec QBM_PJobUpdateState_Bulk @JobsToChange END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default4 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH return end 5