Sending

_Job

Email send job metadata (subject, from, classification). Scoped to the BU where the query runs. Six-month retention.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _Job in the interactive canvas with SQL Sandbox.

Fields (37)

Field Type Flags Relations Description
JobID Number PK — Unique email send job ID.
EmailID Number NULL — Email asset ID.
AccountID Number NULL — Account MID that performed the job.
AccountUserID Number NULL — User ID that performed the job.
FromName Text(130) NULL — From name in the send.
FromEmail Text(100) NULL — From email address.
SchedTime Date NULL — Scheduled send time.
PickupTime Date NULL — Time Marketing Cloud started processing the job.
DeliveredTime Date NULL — Time the send completed.
EventID Text(50) NULL — Job event ID.
IsMultipart Boolean — — Whether the job was sent as multipart MIME.
JobType Text(50) NULL — Job type.
JobStatus Text(50) NULL — Job status.
ModifiedBy Number NULL — User who modified the job.
ModifiedDate Date NULL — Job modification date.
EmailName Text(100) NULL — Email name.
EmailSubject Text(200) NULL — Email subject line.
IsWrapped Boolean — — Whether links were wrapped for tracking.
TestEmailAddr Text(100) NULL — Test email address used.
Category Text(100) — — Job category.
BccEmail Text(100) NULL — BCC email address.
OriginalSchedTime Date NULL — Originally scheduled time.
CreatedDate Date — — Job creation date.
CharacterSet Text(50) NULL — Character set used in the job.
IPAddress Text(50) NULL — Legacy field; always null.
SalesForceTotalSubscriberCount Number — — Total Salesforce subscribers in the job.
SalesForceErrorSubscriberCount Number — — Salesforce subscribers that errored.
SendType Text(50) — — Send type.
DynamicEmailSubject Text(200) NULL — Dynamic subject if used.
SuppressTracking Boolean — — Whether tracking was suppressed.
SendClassificationType Text(50) NULL — Send classification type.
SendClassification Text(200) NULL — Send classification name.
ResolveLinksWithCurrentData Boolean — — Whether links resolved with current data.
EmailSendDefinition Text(200) NULL — Email send definition name.
DeduplicateByEmail Boolean — — Whether deduplication used email addresses.
TriggererSendDefinitionObjectID Text(36) FK, NULL _Sent.TriggererSendDefinitionObjectID
_Open.TriggererSendDefinitionObjectID
_Click.TriggererSendDefinitionObjectID
_Bounce.TriggererSendDefinitionObjectID
_Unsubscribe.TriggererSendDefinitionObjectID
_Complaint.TriggererSendDefinitionObjectID
_FTAF.TriggererSendDefinitionObjectID
_SurveyResponse.TriggererSendDefinitionObjectID		 Triggered send definition object ID.
TriggeredSendCustomerKey Text(36) NULL — Triggered send customer key.

Example query

SELECT TOP 100
  JobID, EmailID, AccountID, AccountUserID, FromName, FromEmail
FROM _Job
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESC

Valid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.