I'm trying to run a query that contains a few joins. It is populating a data extension. However, when I "Run Once", not only does it fill the extension with data, but there is no record in the activity log that it ran successfully or there was an error.
I'm new to MC, It's possible I'm missing something. It's also possible that my query below is not correct. It also seems like I don't have a rock s=olid way of troubleshooting any issues. Is there logging I can turn on somewhere to help?
SELECT o.Id as OutcomeId, c.FirstName as FirstName, c.LastName as LastName, c.Email as Email, c.Id as Id FROM Outcome__c_Salesforce AS o INNER JOIN LOCATIONCONTACT__C_SALESFORCE AS l ON l.Location__c = o.Location__c INNER JOIN Contact_Salesforce AS c ON c.Id = l.Contact__c WHERE o.CreatedDate < DATEADD(hh, 6, getdate()) AND o.CreatedDate > DATEADD(hh, 4, getdate()) AND o.RecordTypeId = '0120W000001YbytQAC'