CheckDataExtensionJobStatus
Retrieves the current status of a data extension job in Salesforce Marketing Cloud. This procedure is used to monitor asynchronous requests that insert or upsert rows into a data extension. It provides feedback on job completion, errors, and processing progress.
Input
| Name | Type | Required | Description |
| RequestId | String | True | Specifies the unique identifier (Id) that is provided by a previously submitted asynchronous insert or update request. This value identifies the original operation whose progress or results are being retrieved. |
Result Set Columns
| Name | Type | Description |
| RequestStatus | String | Indicates the current status of the asynchronous request (for example, 'Pending', 'Completed', or 'Error'). This value reflects the latest state of the job and helps developers monitor processing progress through API responses or automated workflows. |
| ResultStatus | String | Returns the overall outcome of the request (for example, 'Success' or 'Failure'). This field provides high-level completion information that can be used to determine whether subsequent data-retrieval or error-handling steps are required. |
| HasErrors | Boolean | A Boolean field that returns a value of 'true' when the results from processing the request contain one or more errors. It returns a value of 'false' when the request completes successfully without exceptions. This flag helps automate post-processing validation and exception reporting. |
| CallDateTime | Datetime | Records the date and time when the asynchronous request was first received by the system. This timestamp establishes the start point for performance monitoring and API auditing. |
| CompletionDateTime | Datetime | Records the date and time when the asynchronous request completed processing. This value is set automatically by the system and supports reporting on job duration and completion metrics. |
| PickupDateTime | Datetime | Records the date and time when the asynchronous request was picked up from the queue for processing. |
| RequestId | String | Returns the Id of the request that inserted or upserted data rows into the data extension. This output confirms that the system has processed and recorded the referenced job successfully. |