Download Metrics

View this page to View Source Table Metrics.

To access this page:

  1. Click Collect > Targets in Navigation pane.
  2. Click Sources for Target.
  3. Click the Tables iconfor Source.
  4. Click Vertical View for a table
  5. Click General Information tab.
  6. Click View Metrics.
Field Description
TARGET Displays the database where tables are refreshed with source data.
SOURCE Displays the database where data is refreshed from and stored in the target.
TABLE Displays name of the table refreshed from source to target.
JOB ID Displays unique identifier associated with the job that ran the package.
EVENT Displays event name that ran the process.
RECORD COUNT Displays number of records in the table of the target database at the time the table was refreshed by source data.
DURATION Displays amount of time (in seconds) the process took to run.
PROCESS STARTEDON Displays date and time the process (Job ID) started.
PROCESS COMPLETEDON Displays date and time the process (Job ID) completed.
PROCESS MESSAGE Displays message about Job ID returned from SQL Server.
ADDED BY Displays the user ID that started the job (i.e., refreshed the table).
ADDED ON Displays date and time when the job was run (i.e., table was refreshed) by user ID.