_AutomationInstance
Automation Studio run history (1–31 days, real-time, UTC timestamps). One row per automation execution.
Schema last reviewed 2026-06-17
Opens _AutomationInstance in the interactive canvas with SQL Sandbox.
Automation Studio run history (1–31 days, real-time, UTC timestamps). One row per automation execution.
Schema last reviewed 2026-06-17
Opens _AutomationInstance in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
MemberID |
Number | — | — | Business Unit MID. |
AutomationName |
Text(400) | — | — | Automation name. |
AutomationDescription |
Text(400) | NULL | — | Automation description. |
AutomationCustomerKey |
Text(400) | FK | _AutomationActivityInstance.AutomationCustomerKey | Automation external key. |
AutomationInstanceID |
Text(36) | PK, FK | _AutomationInstance.AutomationInstanceID | Unique automation run ID. |
AutomationType |
Text(9) | — | — | Starting source: Schedule, File Drop, or Trigger. |
AutomationNotificationRecipient_Complete |
Text(500) | NULL | — | Completion notification emails. |
AutomationNotificationRecipient_Error |
Text(500) | NULL | — | Error notification emails. |
AutomationNotificationRecipient_Skip |
Text(500) | NULL | — | Skipped-run notification emails. |
AutomationStepCount |
Number | — | — | Number of steps in the automation. |
AutomationInstanceIsRunOnce |
Boolean | — | — | Run-once flag for file drop or triggered runs. |
FilenameFromTrigger |
Text(4000) | NULL | — | File that triggered the run. |
AutomationInstanceScheduledTime_UTC |
Date | NULL | — | Scheduled start time (UTC). |
AutomationInstanceStartTime_UTC |
Date | NULL | — | Actual start time (UTC). |
AutomationInstanceEndTime_UTC |
Date | NULL | — | End time (UTC). |
AutomationInstanceStatus |
Text(400) | — | — | Run status at query time. |
AutomationInstanceActivityErrorDetails |
Text(4000) | NULL | — | First error message from the run. |
SELECT TOP 100
MemberID, AutomationName, AutomationDescription, AutomationCustomerKey, AutomationInstanceID, AutomationType
FROM _AutomationInstanceValid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.