sfmc // SQLPRODUCTION
Find Job IDs for Journey Email Activities
Resolve Journey Builder email activities to their JobID values for reporting and troubleshooting.
sqljobidjourneyemail
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.
SELECT
j.JourneyName,
j.VersionNumber,
ja.ActivityName,
job.JobID,
job.EmailName
FROM _Journey j
INNER JOIN _JourneyActivity ja
ON ja.VersionID = j.VersionID
INNER JOIN _Job job
ON job.TriggererSendDefinitionObjectID = ja.JourneyActivityObjectID
WHERE ja.ActivityType LIKE 'EMAIL%'
AND j.JourneyName = 'JourneyName'Useful when Journey Builder does not expose the Job ID directly in the canvas.