sfmc // Automation HealthSTUDY
Query Activities Trending Toward Timeout
Find Query Activities whose average runtime is already entering the danger zone.
sqlquery activitytimeoutactivitytype
Trust & provenanceSTUDY
Evidence tierSTUDYOfficial sources2Other 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.
Proactive Automation health monitoring.
SELECT
ActivityCustomerKey,
ActivityName,
AVG(DATEDIFF(minute,
ActivityInstanceStartTime_UTC,
ActivityInstanceEndTime_UTC
)) AS AvgDurationMinutes
FROM _AutomationActivityInstance
WHERE ActivityType = 300
GROUP BY ActivityCustomerKey, ActivityName
HAVING AVG(DATEDIFF(minute,
ActivityInstanceStartTime_UTC,
ActivityInstanceEndTime_UTC
)) > 20Salesforce publishes a 30-minute Query Activity hard limit and provides a health example that flags Query Activities averaging more than 20 minutes.
Use this as an early-warning threshold, not a platform limit. The hard Query Activity runtime limit remains 30 minutes.