What do the values in the Status field for dbo.QueueItems and dbo.QueueItemEvents indicate?
The status field for both tables uses the same enumeration.
0 = new, 1 = in progress, 2 = failed, 3 = success, 4 = invalid, 5 = retried, 6 = deleted
QueueItems' status field shows the current state of the QueueItem; the status field in the QueueItemEvents shows the value QueueItem was in at the time of the event.
All the value returned by API can be checked in metadata. To access the same please below URL in below format.