Salesforce Docs Portal

View Bulk Data Load Job Details

When you create update, or delete a large volume of records with the Bulk API or Bulk API 2.0, each job has a Job Detail page where you can monitor the progress of the job.

Required Editions

Available in: both Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions
User Permissions Needed
To monitor bulk data load jobs: Manage Data Integrations, API Enabled, View Setup and Configuration
  1. From Setup, enter Bulk Data Load Jobs in the Quick Find box, then select Bulk Data Load Jobs.
  2. Click a Job ID link for a job.

The job detail page contains the following fields, shown in alphabetical order:

Field Description
Apex Processing Time (ms) The number of milliseconds taken to process triggers and other processes related to the job data. This is the sum of the equivalent times in all batches in the job. This doesn't include the time used for processing asynchronous and batch Apex operations. If there are no triggers, the value is 0.
API Active Processing Time (ms) The number of milliseconds taken to actively process the job and includes the time tracked in the Apex Processing Time (ms) field, but doesn't include the time the job waited in the queue to be processed or the time required for serialization and deserialization. This is the sum of the equivalent times in all batches in the job.
API Version The API version for the job.
Completed Batches The number of batches that have been completed for this job.
Concurrency Mode

The concurrency mode for processing batches. The valid values are:

  • parallel: Batches are processed in parallel mode. This is the default value.
  • serial: Batches are processed in serial mode.
Content Type

The content type for the job. The valid values are:

  • CSV—data in CSV format (default and only supported content type for Bulk V2 type jobs)
  • JSON—data in JSON format
  • XML—data in XML format (default option for Bulk V1 type jobs)
  • ZIP_CSV—data in CSV format in a zip file containing binary attachments
  • ZIP_JSON—data in JSON format in a zip file containing binary attachments
  • ZIP_XML—data in XML format in a zip file containing binary attachments
End Time The date and time when the job completed.
External ID Field The name of the external ID field for an upsert().
Failed Batches The number of batches that have failed for this job.
Job ID The unique, 15–character ID for this job.
Job Type The API type used for the job. Valid values are ‘Bulk V1’, ‘Bulk V2’, and ‘Bulk V2 Query’. Bulk V2 and Bulk V2 Query jobs use the newer Bulk API 2.0 for creating and processing job data. Bulk API 2.0 simplifies the job process by automatically creating batches.
In Progress Batches The number of batches that are in progress for this job.
Object The object type for the data being processed. All data in a job must be of a single object type.
Operations

The processing operation for all the batches in the job. Possible values are:

  • Delete
  • Insert
  • Query
  • QueryAll
  • Upsert
  • Update
  • HardDelete
Progress The percentage of batches processed relative to the total number of batches submitted. Progress isn’t shown when the job is open because the total number of batches in the job isn’t known until the job is closed. Progress may not accurately reflect the number of records processed. Batches may not all contain the same number of records and they might be processed at different speeds.
Queued Batches The number of batches queued for this job.
Records Failed The number of records that weren’t processed successfully in this job.
Records Processed The number of records processed at the time the request was sent. This number increases as more batches are processed.
Retries The number of times that Salesforce attempted to save the results of an operation. The repeated attempts are due to a problem, such as a lock contention.
Start Time The date and time when the job was submitted.
Status

The current state of processing for the job. The valid values are:

  • Open: The job has been created, and data can be added to the job.
  • Closed: No new data can be added to this job. Data associated with the job may be processed after a job is closed. You can’t edit or save a closed job.
  • Aborted: The job has been aborted.
  • Failed: The job has failed. Data that was successfully processed in the job can’t be rolled back.
  • Job Complete: The job was processed by Salesforce. For Bulk API 2.0 jobs only.
  • Upload Complete: No new data can be added to this job. You can’t edit or save a closed job. For Bulk API 2.0 jobs only.
Submitted By The name of the user that submitted the job.
Time to Complete The total time to complete the job.
Total Processing Time (ms) The number of milliseconds taken to process the job. This is the sum of the total processing times for all batches in the job.

The job detail page includes a related list of all the batches for the job. The related list provides View Request and View Response links for each batch. If the batch is a CSV file, the links return the request or response in CSV format. If the batch is an XML or JSON file, the links return the request or response in XML or JSON format, respectively. These links are available for batches created in API version 19.0 and later. For Bulk V2 type jobs, batch information is unavailable.

The batch related list contains the following fields, shown in alphabetical order:

Field Description
Apex Processing Time (ms) The number of milliseconds taken to process triggers and other processes related to the batch data. If there are no triggers, the value is 0. This doesn't include the time used for processing asynchronous and batch Apex operations.
API Active Processing Time (ms) The number of milliseconds taken to actively process the batch, and includes Apex processing time. This doesn't include the time the batch waited in the queue to be processed or the time required for serialization and deserialization.
Batch ID The ID of the batch. Can be globally unique, but doesn’t have to be.
End Time The date and time in the UTC time zone that processing ended. This is only valid when the state is Completed.
Records Failed The number of records that weren’t processed successfully in this batch.
Records Processed The number of records processed in this batch at the time the request was sent. This number increases as more batches are processed.
Retry Count The number of times that Salesforce attempted to save the results of an operation. The repeated attempts are due to a problem, such as lock contention or a batch taking too long to process.
Start Time The date and time in the UTC time zone when the batch was created. This isn’t the time processing began, but the time the batch was added to the job.
State Message Contains the reasons for failure if the batch didn't complete successfully.
Status

The current state of processing for the batch:

  • Queued: Processing of the batch hasn’t started yet. If the job associated with this batch is aborted, the batch isn’t processed and its state is set to NotProcessed.
  • In Progress: The batch is being processed. If the job associated with the batch is aborted, the batch is still processed to completion. You must close the job associated with the batch so that the batch can finish processing.
  • Completed: The batch has been processed completely, and the result resource is available. The result resource indicates if some records have failed. A batch can be completed even if some or all the records have failed. If a subset of records failed, the successful records aren’t rolled back.
  • Failed: The batch failed to process the full request due to an unexpected error, such as the request is compressed with an unsupported format, or an internal server error.
  • Not Processed: The batch failed to process the full request due to an unexpected error, such as the request is compressed with an unsupported format, or an internal server error.
Total Processing Time (ms) The number of milliseconds taken to process the batch. This excludes the time the batch waited in the queue to be processed.
View Request Click the link for a batch to see the request. Bulk V1 type jobs only.
View Result Click the link for a batch to see the results. Bulk V1 type jobs only.

See Also