Using the DBAmp_Log Table
Using the DBAmp_Log Table
All DBAmp stored procedures write their output messages to the DBAmp_Log table that the DBAmp Performance Package creates. By querying this table, you can view the message output from recently executed DBAmp stored procedures. This allows you to view information and find any errors related to each procedure execution. This screenshot shows a typical DBAmp_Log table:
The columns in the table are:
Column Name | Documentation |
---|---|
SPName | Unique ID of each execution |
Status | Status of the execution |
Message | All messages related to each execution |
LogTime | The date and time the execution started (status = starting) and ended (status = successful/failed) |
Run the statement below to select all rows and columns of the DBAmp_Log table:
SELECT * FROM DBAmp_Log