Parent-aware ack. Deletes a childless job, suspends one whose children are still running, and wakes a suspended parent whose last child left the queue. Returns 1, or 0 for a job gone, reclaimed or cancelled. When archiveEnabled, the deleted row is teed into the archive per-row on archive_for.

Set-based smart ack over unnested (id, claim_seq) arrays. Deletes leaves, suspends finalizers that still have children, and wakes parents whose last child completed. The wake check excludes acked children explicitly. Returns the ids acked or suspended. Gone or reclaimed jobs are absent. Locks rows in descending id order. The caller holds the parent locks.

Extend a job's visibility timeout. Matches on the claim token and does not check the holder. Suspended rows hold no lease. secs at or below 0 clears the lease.

setVisibilityTimeoutSQL over a batch, for the heartbeat. Extends every job still under this claim, held by the same worker and unsuspended, and reports per row whether the update landed alongside its claim token, holder, cancel flag and suspension. secs at or below 0 clears the lease. The statement never waits on a lock. It takes the group summaries first, then the rows, both with SKIP LOCKED, and a row whose summary or row is busy reads back unchanged. The caller attaches the row decoder.

Park a failed job for its retry backoff. Matches on the claim token.

Soft nack. Releases the claim and hands back the attempt it consumed, recording no failure. A delay in seconds parks the job for that long. Without one, not_visible_until stands.

nackJobSQL over unnested (id, claim_seq, attempts) arrays. Locks rows in descending id order. Returns the ids nacked.

Make a delayed or retrying job immediately visible. Refuses an in-flight or suspended job.

Set when a job next becomes visible, clear its throttle marker and void a lapsed claim. Refuses an in-flight, suspended, force-cancel-flagged or exhausted job.