Email JobsPRODUCTION

_Job

Email send job metadata such as email name, status, sender and scheduling information.

Time: CST; DST not observed

Trust & provenancePRODUCTION

Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

Starter query

Start from something valid.

SELECT
    jo.JobID,
    jo.EmailName,
    jo.EmailSubject,
    jo.JobStatus,
    jo.SchedTime
FROM _Job jo

Relationships

Where it connects.

_Job → _Sent

JobID = JobID

→

_Job → _JourneyActivity

TriggererSendDefinitionObjectID = JourneyActivityObjectID

→

Schema

Fields

Field	Type	Flags	Notes
`JobID`	Number	INDEXED	Send job identifier.
`EmailID`	Number	NULLABLE	Email asset identifier.
`AccountID`	Number	NULLABLE	Account that performed the job.
`AccountUserID`	Number	NULLABLE	User that performed the job.
`FromName`	Text(130)	NULLABLE	Configured from name.
`FromEmail`	Email(100)	NULLABLE	Configured sender email/fallback.
`SchedTime`	Date	NULLABLE	Scheduled time.
`PickupTime`	Date	NULLABLE	Processing start time.
`DeliveredTime`	Date	NULLABLE	Delivery time; triggered sends can be null.
`JobType`	Text(50)	NULLABLE	Job type.
`JobStatus`	Text(50)	NULLABLE	Job status.
`EmailName`	Text(100)	NULLABLE	Email name.
`EmailSubject`	Text(200)	NULLABLE	Email subject.
`TriggererSendDefinitionObjectID`	Text(36)	NULLABLE	Triggered Send definition ID used to correlate Journey email activities.

Operational notes

Results are scoped to email send jobs in the current business unit.

Verified sources

Salesforce — Data View: Job ↗

_Job

Start from something valid.

Where it connects.

Fields

Keep following the context.