Utility Procedures
Technical Details

Technical details for Utility Procedures used by dbOmnibus.

| Procedure List |

These utility procedures are used internally by dbOmnibus and are not intended to be executed manually.


sp_UpdateLastCaptured

Update the [LastCaptured] column in the [_EntityVersions] table for a SP run.

This is called by each relevant capture activity.

Parameters:

Provide either the Table, Proc name or both.
@TableName - Name of the tables being updated.
@ProcName - Name of the procedure performing the update process.

Usage:

EXEC [Util].[sp_UpdateLastCaptured] @TableName = '', @ProcName = ''

If either @TableName or @ProcName are blank, the procedure assumes that the other is populated and performs the appropriate logic. If both are empty, the procedure does nothing. It is expected that one or the other will have a value.

 


Page Last Updated: 21 September 2025