Collect

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.