Skip to main content

Monitoring and Logging

A variety of monitoring and logging capabilities are available for all operations.

SLAM_Activity_Log Table (All Operations)​

All operations automatically create entries in the SLAM_Activity_Log table with:

  • Operation details (type, user, organization info)
  • Performance metrics (start/end times, record counts)
  • Success/failure status
  • Options used for the operation

The ProcessId column in the activity log records the Windows process ID of the running operation. This can be used with SLAM_abort to stop a running operation from another SQL session.

Row Level Results (Load Operations)​

Every data load operation results in the following columns being added to the input table:

  • SLAM_Message - the end result of the operation: 'Operation Successful.' or an error message return by Salesforce
  • SLAM_unique_id (as needed) - a generated unique identifier if there is no available key column in the input table

The two SLAM_* fields are not loaded into the Salesforce object, but as responses are received from Salesforce, the SLAM_* fields are populated and the Id column is written with the Salesforce Id from the response.

Bulk Job Log (All Bulk and Bulkv2 Operations)​

All load and query operations using the Bulk or Bulkv2 APIs are logged by Salesforce and this logging can be found at in Salesforce at Setup > Quick Find > Bulk Data Load Jobs.