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].

Untitled

See the details about Quartz here.