ODBC Driver for Salesforce

Build 24.0.9060

GetJob

Gets information about a Salesforce job.

Input

Name Type Description
JobId String Id of the job being retrieved.

Result Set Columns

Name Type Description
ID String The Id of the job.
JobID String The Id of the job.
ObjectName String The name of the object to be used with the job.
Operation String The operation for the job. For example, delete, insert, query, upsert, update, or hardDelete.
ApiVersion String The API version of the job set in the URI when the job was created. The earliest supported version is 17.0.
ApexProcessingTime String 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 does not include the time used for processing asynchronous and batch Apex operations. If there are no triggers, the value is 0. This field is available in API version 19.0 and later.
ApiActiveProcessingTime String The number of milliseconds taken to actively process the job. This value includes ApexProcessingTime but not 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. This field is available in API version 19.0 and later.
AssignmentRuleId String The Id of a specific assignment rule to run for a case or a lead. The assignment rule can be active or inactive.
ConcurrencyMode String The concurrency mode for the job. The valid values are: parallel and serial.
ContentType String The content type for the job. The valid values are: CSV, XML, ZIP_CSV, and ZIP_XML.
CreatedById String Id of the user who created the job.
CreatedDate String Date the job was created.
ExternalIdFieldName String The name of the external Id field for an upsert.
NumberBatchesCompleted String The number of batches that have been completed for this job.
NumberBatchesQueued String The number of batches queued for this job.
NumberBatchesFailed String The number of batches that have failed for this job.
NumberBatchesInProgress String The number of batches that are in progress for this job.
NumberBatchesTotal String The number of total batches currently in the job. This value increases as more batches are added to the job. When the jobstate is Closed or Failed, this number represents the final total. The job is complete when NumberBatchesTotal equals the sum of NumberBatchesCompleted and NumberBatchesFailed.
NumberRecordsFailed String The number of records that were not processed successfully in this job. This field is available in API version 19.0 and later.
NumberRecordsProcessed String The number of records already processed. This number increases as more batches are processed.
NumberRetries String 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.
State String The state of the job. For example, Open, Closed, Aborted, or Failed.
SystemModStamp String Date and time in the UTC time zone when the job finished.
TotalProcessingTime String The number of milliseconds taken to process the job. This is the sum of the total processing times for all batches in the job. See also ApexProcessingTime and ApiActiveProcessingTime. This field is available in API version 19.0 and later.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060