sfmc // Journey BuilderPRODUCTION
Journey Email Sends in the Last 24 Hours
See recent Journey email sends with Journey/version/activity context.
sqljourneysent24h
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verified2026-10-05
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.
Post-deploy validation.
Checking whether a running Journey actually produced send events.
SELECT
s.EventDate AS SendDate,
s.SubscriberKey,
j.JourneyName,
j.VersionNumber,
ja.ActivityName
FROM _Sent s
INNER JOIN _JourneyActivity ja
ON s.TriggererSendDefinitionObjectID = ja.JourneyActivityObjectID
INNER JOIN _Journey j
ON ja.VersionID = j.VersionID
WHERE s.EventDate >= DATEADD(hour,-24,GETDATE())
AND ja.ActivityType LIKE 'EMAIL%'_Sent bridges to _JourneyActivity using TriggererSendDefinitionObjectID, then to _Journey by VersionID.