A scheduler job,
Atatus: Active; Active From: Always; Active To: Always; Interval: Every2minutes; Job: function::runMassEmailCampaign
Stopped wordking:
Last Successful Run: 13.09.2022 03:26
Currently it is the same day but 09:23.
Staus as above = Active
suitecrm.log does not help me. It mentions the last “Run Mass Email Campaigns 0-24 neu” from 13.09.2022 01:22:01, so two hours earlier:
SET assigned_user_id=‘1’,name=‘Run Mass Email Campaigns 0-24 neu’,date_modified=‘2022-09-13 01:22:01’,scheduler_id=‘dcbe0484-2569-890a-ac04-63186cd1e979’,execute_time=‘2022-09-13 01:22:00’,status=‘done’,resolution=‘success’,message=NULL,target=‘function::runMassEmailCampaign’,data=NULL,requeue=0,retry_count=NULL,failure_count=NULL,job_delay=0,client=‘CRONd61eadcfcba9c5819e0ce84865b91178:17799’,percent_complete=NULL
WHERE job_queue.id = ‘d734490e-f8a2-57a2-1202-631fdb3851e8’ AND deleted=0)
However the log contails several entries with
SOME DATE [18956][1][FATAL] Slow Query (time:0.56159400939941…
I had this problem before.
Tried some Admin repair tools. Did not help.
Deactivated and activate the Scheduler Job. Did not help.
All other Suite CRM Scheduler Jobs run fine.
Finallay it created a new Scheduler that does the same. That then works fine for a while until ist stops working after a few hours of work.
Well, is seems only to stop weorking when there is mails to be sent.
Also it dod work for a few months.
Any help is more than apreciated…