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:

alt text

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