Related to #73. Alongside EXECUTION_GROUP, the schema is also missing the two optional QRTZ_TRIGGERS columns Quartz.NET 3.19.0 added for node affinity (TriggerBuilder.WithPreferredNode(...)). AdoJobStore probes for them on startup and logs a warning when they are absent.
PREFERRED_NODE — NVARCHAR(200) NULL (SQL Server) / VARCHAR(200) NULL (PostgreSQL, MySQL)PREFERRED_NODE_AUTO — BIT NOT NULL DEFAULT 0 (SQL Server) / BOOL NOT NULL DEFAULT FALSE (PostgreSQL, MySQL)- Both must be added together — Quartz only enables node affinity when both are present.
- Reference migration:
database/schema_30_add_preferred_node.sql (covers all providers).
For context, of the three optional columns added across Quartz 3.17–3.19, MISFIRE_ORIG_FIRE_TIME is mapped as of 0.6.0, EXECUTION_GROUP is #73, and these two are the remaining gap.
Related to #73. Alongside
EXECUTION_GROUP, the schema is also missing the two optionalQRTZ_TRIGGERScolumns Quartz.NET 3.19.0 added for node affinity (TriggerBuilder.WithPreferredNode(...)).AdoJobStoreprobes for them on startup and logs a warning when they are absent.PREFERRED_NODE—NVARCHAR(200) NULL(SQL Server) /VARCHAR(200) NULL(PostgreSQL, MySQL)PREFERRED_NODE_AUTO—BIT NOT NULL DEFAULT 0(SQL Server) /BOOL NOT NULL DEFAULT FALSE(PostgreSQL, MySQL)database/schema_30_add_preferred_node.sql(covers all providers).For context, of the three optional columns added across Quartz 3.17–3.19,
MISFIRE_ORIG_FIRE_TIMEis mapped as of 0.6.0,EXECUTION_GROUPis #73, and these two are the remaining gap.