You are here:
Data View: Job
To view email send job data, query the _Job data view in Automation Studio.
Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
JobID is an indexed field.
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| JobID | The job ID number for the email send | int | Number | |
| EmailID | The email ID for the job | int | Number | X |
| AccountID | The ID number for the account that performed the job | int | Number | X |
| AccountUserID | The ID number for the account user that performed the job | int | Number | X |
| FromName | The from name in the email send When you use a Dynamic Sender Profile, the FromName is the personalization string, such as %%FromName%% set in the profile. It’s not the actual name that appears when the email is sent. |
nvarchar(130) | Text | X |
| FromEmail | The from email address in the email send When you use a Dynamic Sender Profile, this field shows the fallback email address that is configured in the sender profile. It’s not the specific address used when the email is sent. |
varchar(100) | X | |
| SchedTime | The time the job was scheduled | smalldatetime | Date | X |
| PickupTime | The time Marketing Cloud Engagement started the job | smalldatetime | Date | X |
| DeliveredTime | The time the email was delivered For any triggered send this field shows
|
smalldatetime | Date | X |
| EventID | The ID for the job event | varchar(50) | Text | X |
| IsMultipart | Whether the job was sent as multipart MIME or not | bit | Boolean | |
| JobType | The type of job | varchar(50) | Text | X |
| JobStatus | The status of the job | varchar(50) | Text | X |
| ModifiedBy | If modified, the user who modified the job | int | Number | X |
| ModifiedDate | The date the job was modified | datetime | Date | X |
| EmailName | The name of the email sent by the job | char(100) | Text | X |
| EmailSubject | The subject of the email send | nchar(200) | Text | X |
| IsWrapped | Whether the links in the email were wrapped for tracking | bit | Boolean | |
| TestEmailAddr | The test email address used in the job | varchar(128) | X | |
| Category | The job category | varchar(100) | Text | |
| BccEmail | Any email address send in the BCC field | varchar(100) | X | |
| OriginalSchedTime | The original scheduled time for the job | smalldatetime | Date | X |
| CreatedDate | The date the job was created | smalldatetime | Date | |
| CharacterSet | The character set used in the job | varchar(30) | Text | X |
| IPAddress | This value is always null. | varchar(50) | Text | X |
| SalesForceTotalSubscriberCount | The total number of Salesforce subscribers included in the job | int | Number | |
| SalesForceErrorSubscriberCount | The total number of Salesforce subscribers included in the job that received errors | int | Number | |
| SendType | The type of send used in the job | varchar(128) | Text | |
| DynamicEmailSubject | The dynamic email subject included in the job | ntext | Text | X |
| SuppressTracking | If tracking information for this job was suppressed | bit | Boolean | |
| SendClassificationType | The send classification type for the job | nvarchar(32) | Text | X |
| SendClassification | The send classification for the job | nvarchar(36) | Text | X |
| ResolveLinksWithCurrentData | If the job resolved links with current data | bit | Boolean | |
| EmailSendDefinition | The email send definition used in the job | nvarchar(36) | Text | X |
| DeduplicateByEmail | Whether the email addresses in the job are used to deduplicate subscribers | bit | Boolean | |
| TriggererSendDefinitionObjectID | The object ID for the triggered send definition | uniqueidentifier | null | X |
| TriggeredSendCustomerKey | The customer key for the triggered send | varchar(36) | Text | X |
