Back to OIM Explorer

dbo.QBM_PJobQueueSetSameServer

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 687 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 source dbo.QBM_FTJobQueueSetSameServer source text reference

References

Referenced By

Complete Source

SQL30 lines
1CREATE PROCEDURE QBM_PJobQueueSetSameServer(2  @uid_job varchar(38)3)4AS5BEGIN6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  DECLARE @Xdate datetime = getutcdate()8  SET XACT_ABORT OFF9  BEGIN TRY10    UPDATE jobqueue11    SET UID_JobSameServer = n.UID_JobSameServerNew,12    XDateUpdated = @Xdate,13    XUserUpdated = @XUser14    FROM dbo.QBM_FTJobQueueSetSameServer(@uid_job) n15    JOIN JobQueue q16      ON n.UID_Job = q.UID_Job17    WHERE18      n.UID_JobSameServerNew > ' ' AND n.UID_JobSameServerNew <> q.UID_JobSameServer19  END TRY20  BEGIN CATCH21    EXEC QBM_PSessionErrorAdd DEFAULT22    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()23    RAISERROR(@Rethrow,24    18,25    1)26      WITH NOWAIT27  END CATCH28  ende:29  RETURN30END
Open raw exported source
SQL ยท Raw6 lines
1  create   procedure QBM_PJobQueueSetSameServer (@uid_job varchar(38))  as begin  declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate2 datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY  update jobqueue set UID_JobSameServer = n.UID_JobSameServerNew  , XDateUpdated = @Xdate , XUserUpdated3 = @XUser from dbo.QBM_FTJobQueueSetSameServer(@uid_job) n join JobQueue q on n.UID_Job = q.UID_Job where n.UID_JobSameServerNew > ' ' and n.UID_JobSameServerNew4 <> q.UID_JobSameServer END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR5 (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 6