Redrive and dead letters

failed rows are the dead-letter set. They stay hot for inspection via queue retention settings.

Observer-facing views include taskq.dead_jobs. Operators redrive through SQL (or the HTTP operator surface when mounted):

SELECT * FROM taskq.dead_jobs LIMIT 50;

SELECT taskq.redrive_job(id, 'operator:andi')
FROM taskq.jobs
WHERE status = 'failed' AND queue = 'courts';

Redrive resets budgets and returns the job to queued. If another active job already holds the same idempotency key, redrive fails with TQ409.