Can I query if a subscriber has any scheduled emails in Marketing Cloud?

Question

I am aware that we can look at the _Sent data view to see what emails have been sent to Subscribers in past context.

What I would like to know if there is a way we can query if there are any scheduled sends for a particular person?

I know the _Job view you can see what emails are scheduled to be sent out, however this is only an overview of the job and from what I can see it doesn't contain information about what Subscribers are in the job.

Thanks in advance.

Answer 1

You can query like below

Select S.SubscriberId, J.SchedTime 
from _Sent S
inner join _Job J
on J.JobID = S.JobID
where S.SubscriberID = 'Input the SubscriberID in question'

The above will give you if a subscriberId is part of the scheduled send.