Back to OIM Explorer

dbo.RPS_PAfterMigrationTasks

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QER-K-AllChildrenOfOrg / QER_ZAllChildrenOfOrg at line 5; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 883 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> QER-K-AllChildrenOfOrg / QER_ZAllChildrenOfOrg at line 5
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QER_ZAllChildrenOfOrg at line 5 Bulk DBQueue insert -> QER-K-AllChildrenOfOrg / QER_ZAllChildrenOfOrg at line 5
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QER-K-AllChildrenOfOrg -> QER_ZAllChildrenOfOrg QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL42 lines
1CREATE PROCEDURE RPS_PAfterMigrationTasks(2  @GenProcID varchar(38)3)4AS5BEGIN6  SET XACT_ABORT OFF7  BEGIN TRY8    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw9    INSERT INTO @DBQueueElements_01(object,10    subobject,11    genprocid)12    SELECT13      x.uid,14      x.subobject,15      @GenProcID16    FROM(17    SELECT18      y.UID_Org AS uid,19      'RPS-K-OrgHasRPSReport' AS subobject20    FROM BaseTree y21    WHERE22      y.UID_Org LIKE '___-%' AND y.XUserUpdated LIKE 'QBM_PBufferT_Process%' AND y.XDateUpdated > GETUTCDATE() -123    UNION24    SELECT25      y.UID_Org AS uid,26      'RPS-K-OrgHasRPSReport' AS subobject27    FROM BaseTreeHasRPSReport y28    WHERE29      y.UID_Org LIKE '___-%' AND y.XUserUpdated LIKE 'QBM_PBufferT_Process%' AND y.XDateUpdated > GETUTCDATE() -1) AS x30    EXEC QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg',31      @DBQueueElements_0132  END TRY33  BEGIN CATCH34    EXEC QBM_PSessionErrorAdd DEFAULT35    RAISERROR('',36    18,37    1)38      WITH NOWAIT39  END CATCH40  endLabel:41  RETURN42END
Open raw exported source
SQL ยท Raw7 lines
1 create   procedure RPS_PAfterMigrationTasks (@GenProcID varchar(38) ) as begin SET XACT_ABORT OFF BEGIN TRY  declare @DBQueueElements_01 QBM_YDBQueueRaw2 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, x.subobject, @GenProcID from ( select y.UID_Org as uid , 'RPS-K-OrgHasRPSReport'3 as subobject from BaseTree y where y.UID_Org like '___-%'  and y.XUserUpdated like 'QBM_PBufferT_Process%' and y.XDateUpdated > GETUTCDATE() -1 union 4select y.UID_Org as uid , 'RPS-K-OrgHasRPSReport' as subobject from BaseTreeHasRPSReport y where y.UID_Org like '___-%'  and y.XUserUpdated like 'QBM_PBufferT_Process%'5 and y.XDateUpdated > GETUTCDATE() -1 ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg', @DBQueueElements_01   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd6 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 7