The SendJobs file represents all sends with activity logged against them for the timeframe of the extract. This list reflects only jobs that already processed. Sends scheduled for the future do not appear in this list.
Once the tracking extract process creates a SendJobs table, the only column value that can change is JobStatus. All other data associated with the job is static. JobStatus only changes if the send processes during the extract and completes at a later date.
Output Types
- CSV
- TAB
Columns
| Name | Description | Possible Values | Data Type | Character Length |
|---|---|---|---|---|
| ClientID | The system account identifier associated with attribute set | -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) | Numeric | Maximum length - big integer |
| SendID or JobID | Identifier associated to an email send | Numeric | Maximum length - big integer | |
| FromName | From name associated with the send. For On-Your-Behalf sends, this value contains the ChannelMember personalization strings. | String | 130 | |
| FromEmail | From email address associated with the send. For On-Your-Behalf sends, this value contains the ChannelMember personalization strings. | String | 100 | |
| SchedTime | Schedule date and time of the send | Datetime | Small | |
| SentTime | Message delivery date and time to Marketing Cloud Engagement | Datetime | Small | |
| Subject | Subject line of email associated with the send | String | 200, but can exceed this value depending on selected extract options | |
| EmailName | Name of email associated with the send | String | 100 | |
| TriggeredSendExternalKey | External key associated to a triggered send definition if send resulted from a triggered send request | String | 100 | |
| SendDefinitionExternalKey | External key associated to the user-initiated send definition that initiated send, as applicable | String | 100 | |
| JobStatus | Current job status |
|
String | 30 |
| PreviewURL | Link to preview of email sent to subscriber. Preview does not incorporate personalization. | String | 300 | |
| IsMultipart | Specifies if email sent in multipart MIME |
|
Boolean | 5 |
| Additional | EventID entered at time of send | String | 50 |