public virtual Task<IEnumerable<InvocationState>> GetLatestByJob()
{
return ConnectAndQuery(@"
WITH cte AS (
SELECT *, ROW_NUMBER() OVER (PARTITION BY Job ORDER BY [UpdatedAt] DESC) AS rn
FROM [work].Invocations
)
SELECT *
FROM cte
WHERE rn = 1");
}