HangFire log

get-failed-state-exception.sql

SELECT TOP (1000) q.[Id], q.[JobId], q.[Name], q.[Reason], q.[CreatedAt], q.[Data]
FROM [SimplesNacional.Task].[HangFire].[State] q
INNER JOIN
(
  SELECT
    MAX(x.id) stateid,
    x.jobid
  FROM [SimplesNacional.Task].[HangFire].[State] x
  WHERE x.name = 'Failed'
  AND x.jobid IN
  (
    SELECT
      j.id
    FROM [SimplesNacional.Task].[HangFire].[Job] j
    WHERE j.statename = 'Failed'
  )
  GROUP BY x.jobid
) xxx
  ON q.id = xxx.stateid