Can you please check by sending a test email that how much time a test email to reset for being send from CRM?
Also please enable Log slow query from system settings and also set the CRM logger level to Debug.
By doing this all I am hopeful that you will find out the issue.
I ran the query “delete FROM ‘job_queue where status= ‘done’……”.
I originally uploaded 3523 “leads” to the system. When I looked at my data base I found I had 6100+ “leads”. A lot of them have “1” in the “delete” column. Evidently I uploaded the same “leads” twice. I ran the “Prune Database on 1st of Month” in the scheduler. That removed about half the records in the database.
I setup a new “Campaign” set to be sent out at 10:00 am this morning. The scheduled “Run Nightly Mass Email Campaigns” started at 2:00 am and completed at 6:00 am this morning.
As of this time none of the emails have been sent out.
Can you tell me how to clear up the “aod_indexevent table” as mentioned before?
But get ready for a long process of reindexing, it might be better to do it overnight.
As for the Campaigns, I would try doing campaigns with a much smaller number of targets (say: 3) and have the job to send run much more frequently (like every 5 minutes). This way you would do more tests and you could find out if you have additional problems (for example, email errors, SMTP stuff, etc).