After a long time it worked fine, but in the last 2 days I haven't seen it activated anymore, even though the status is active and I tried triggering it manually but it still doesn't work.

I realized one thing is next_execution_time is empty, i think this is the problem.