server.web.models.task_status_audit

Task Status Audit Database Table.

Classes

TaskStatusAudit

Audit log for task status transitions - supports timeseries queries.

Module Contents

class server.web.models.task_status_audit.TaskStatusAudit

Bases: jobmon.server.web.models.Base

Audit log for task status transitions - supports timeseries queries.

Each record tracks when a task entered a status (entered_at) and when it exited that status (exited_at). This allows efficient queries for concurrent task counts without needing window functions.

id: sqlalchemy.orm.Mapped[int]
task_id: sqlalchemy.orm.Mapped[int]
workflow_id: sqlalchemy.orm.Mapped[int]
previous_status: sqlalchemy.orm.Mapped[str | None]
new_status: sqlalchemy.orm.Mapped[str]
entered_at: sqlalchemy.orm.Mapped[datetime.datetime]
exited_at: sqlalchemy.orm.Mapped[datetime.datetime | None]