Documentation

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 acked ids. Reclaimed jobs are absent. Locks children-first to match nack and force-cancel. The caller holds the parent locks.

Extend a job's visibility timeout. Matches on the claim token. Suspended rows hold no 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, cancel flag and suspension. valuesFrag carries the input (id, claim_seq, claimed_by) rows.

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. Leaves not_visible_until as it stands.

nackJobSQL over unnested (id, claim_seq, attempts) arrays, locking children-first to match ack and force-cancel. Returns the ids nacked.

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