Expand my Community achievements bar.

Query Service - Last Run Timestamp - what does it specifically means ?

Avatar

Level 10

I have query scheduled for 5 AM. Last run Timestamp is 6:09

Does it mean that it run at 6:09 or it finished at 6:09 ?

Marked as blue color:

Michael_Soprano_0-1767543746400.png

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Community Advisor

@Michael_Soprano Per doc  Last run timestamp—The most recent timestamp when the query was run. This column highlights whether a query has been executed according to its current schedule. More details here

Avatar

Level 10

Thanks. 

Could you confirm if:

1. Schedule is set up in UTC time 

2. Last run timestamp is based on my computer datetime ?

Avatar

Community Advisor

To your two specifics:

  1. Schedule timezone

    • Yes. When you configure a schedule in the UI (Daily/Weekly, etc.), the time you pick is interpreted in UTC, not your local time zone.

  2. Last run timestamp timezone

    • The underlying run time is stored in UTC, but the UI renders “Last run timestamp” in a human‑readable format based on the console/UI context, not your local machine clock; it does not dynamically read your computer time settings.

Ref: https://experienceleague.adobe.com/en/docs/experience-platform/query/ui/query-schedules