--- schema_version: "1" id: 12f3afc9b81b6b15bc1522c84efae2c8cea175a41bbe69e9eb6185dc309ee7a9 title: "Data View: Job" collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_data_view_job.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_data_view_job.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 1b3f7092d9c04810023a3da9e2d3436c4e67d5876ac720363b10130a65d46677 description: To view email send job data, query the _Job data view in Automation Studio. products: - Marketing - Marketing Cloud Engagement release: "264" --- # 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. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png) Note When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the \_EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results from profile attribute columns in addition to the columns listed here. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png) Note The Job data view provides results for all email send jobs in your current business unit. The data view doesn’t categorize the results by send method. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_journeys_and_automations-264-0-0-production-enus/e08cdd71-c1c1-4ae5-a5e9-8a6dad583ad4/images/icon_note.png) Note The EmailSubject field allows up to 200 characters, but subject lines may be cut off between 30 to 60 characters on different devices and browsers. Preview on multiple devices for best readability. 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) Email 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 NULL. Because these sends are processed over an extended period, there isn't a single delivery time for all subscribers.

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) Email X
Category The job category varchar(100) Text  
BccEmail Any email address send in the BCC field varchar(100) Email 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