Campaign Emails get stuck in queue

Hi Jessica,

It looks like you've covered most of these scenarios, but I wanted to share an article from our Knowledge Base, Troubleshooting Campaigns Failing to Send From Email Queue which may provide some troubleshooting clues. Also, Creating a Campaign provides a comprehensive view of the campaign process from beginning to end which may also help to ensure all steps have been taken. 

I hope this helps!
Alex 

Hi Jessica,

It looks like you've covered most of these scenarios, but I wanted to share an article from our Knowledge Base, Troubleshooting Campaigns Failing to Send From Email Queue which may provide some troubleshooting clues. Also, Creating a Campaign provides a comprehensive view of the campaign process from beginning to end which may also help to ensure all steps have been taken. 

I hope this helps!
Alex 

Yeah, we already tried going through these articles but couldn't figure out why it isn't working. Is there anything else that might cause this to not work? Note we host our instance of SugarCRM on a local server, not the sugarondemand cloud platform. Not sure if that makes a difference? 

I got a solution that looks some tricky but works for me many times. This will need direct DB access.

You will need to run this sql if you think your emails are getting stuck in queue for any reason.

As i said , this is just a trick for me , it will not solve a real problem.