Issue: no changes are logging.
Solution: check the Quartz trigger log for states and last launch dates for [TsiChangeLogQueueProcessJobTrigger].
To do this, run the script:
SELECT CAST(HASHBYTES('MD4', t.SCHED_NAME + t.TRIGGER_NAME + t.TRIGGER_GROUP) AS UNIQUEIDENTIFIER) UsrId,
t.TRIGGER_NAME UsrTriggerName, -- Name,
t.TRIGGER_GROUP UsrTriggerGroup, -- Group
t.[DESCRIPTION] UsrDescription, -- Description
CAST(PREV_FIRE_TIME/864000000000.0 -693595.0 AS DATETIME) UsrPrevFireTime, -- Date of previous launch (UTC)
CAST(NEXT_FIRE_TIME/864000000000.0 -693595.0 AS DATETIME) UsrNextFireTime, -- Date of next launch (UTC)
TRIGGER_STATE UsrTriggerState, -- State
TRIGGER_TYPE UsrTriggerType, -- Type
CAST(START_TIME/864000000000.0 -693595.0 AS DATETIME) UsrStartTime, -- Start date (UTC)
CAST(END_TIME/864000000000.0 -693595.0 AS DATETIME) UsrEndTime, -- End date (UTC)
c.TIME_ZONE_ID UsrTimeZoneID, -- Time zone
c.CRON_EXPRESSION UsrCronExpression -- CRON expression (start frequency)
FROM QRTZ_TRIGGERS t
LEFT JOIN QRTZ_CRON_TRIGGERS c ON (c.SCHED_NAME = t.SCHED_NAME AND c.TRIGGER_NAME = t.TRIGGER_NAME
AND c.TRIGGER_GROUP = t.TRIGGER_GROUP)
where t.TRIGGER_NAME LIKE '%ChangeLog%'
If [UsrTriggerState] = "Bloсked" and/or [UsrNextFireTime] is less than the current date, set the [UsrNextFireTime] field to the value of the current date and time using [RunImmediate].
See the details about Quartz here.