0

I'm trying to run a query to a data extension to grab info in the last 30 days from the _Job data view.

I continue to get the error:

"_Job is not a known data extension or system dat view."

This is the query I'm using. Can anyone see what the problem might be?

SELECT
JobID,
EmailID,
AccountID,
EventID,
JobType,
EmailName,
EmailSubject,
EmailSendDefinition,
DeliveredTime
FROM
    _Job
WHERE
    DeliveredTime >= getdate()-30
2

System Data Views have to be enabled by SFMC Support. There's no cost.

  • Had same issue, when support enabled it, everything was ok again :-) – Bidstrup Jan 15 '16 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.