Automation HealthPRODUCTION
_AutomationActivityInstance
Activity-level execution health for Automation Studio: runtime, activity type, status and error details.
Retention: Past 6 monthsScope: Single business unitTime: UTC
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded
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.
Starter query
Start from something valid.
SELECT
au.AutomationCustomerKey,
au.ActivityName,
au.ActivityType,
au.ActivityInstanceStatus,
au.ActivityInstanceStartTime_UTC,
au.ActivityInstanceEndTime_UTC
FROM _AutomationActivityInstance auRelationships
Where it connects.
Schema
Fields
| Field | Type | Flags | Notes |
|---|---|---|---|
MemberID | Number | Business Unit identifier. | |
JobID | Number | NULLABLE | Email job identifier when applicable. |
AutomationName | Text(400) | Parent automation name. | |
AutomationCustomerKey | Text(400) | Parent automation customer key. | |
AutomationInstanceID | Text / UUID | INDEXED | Parent automation-run identifier. |
ActivityType | Number | Numeric activity type identifier. | |
ActivityName | Text(400) | Activity name. | |
ActivityCustomerKey | Text(400) | INDEXED | Unique activity customer key. |
ActivityInstanceStep | Text(25) | Automation position, for example 3.2. | |
ActivityInstanceID | Text / UUID | Unique activity-execution identifier. | |
ActivityInstanceStartTime_UTC | Date | NULLABLE | Activity execution start time. |
ActivityInstanceEndTime_UTC | Date | NULLABLE | Activity execution end time. |
ActivityInstanceStatus | Text(256) | Initialized, Executing, Complete, Error or NotSelected. | |
ActivityInstanceStatusDetails | Text(4000) | NULLABLE | Activity error/log detail when available. |
Operational notes
Salesforce examples identify Query Activity as ActivityType 300 and SSJS Script Activity as ActivityType 150.
Use this view to find repeated failures and activities trending toward the 30-minute runtime ceiling.
Verified sources