From ce5f98aaacb6624acab94b4e502e45c46fb504e6 Mon Sep 17 00:00:00 2001
From: JKingsnorth <john@johnkingsnorth.co.uk>
Date: Tue, 5 Jan 2016 11:16:30 +0000
Subject: [PATCH] CRM-17631: Process mailing jobs by scheduled date

---
 CRM/Mailing/BAO/MailingJob.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/CRM/Mailing/BAO/MailingJob.php b/CRM/Mailing/BAO/MailingJob.php
index 182265b34c..61a62b1b0c 100644
--- a/CRM/Mailing/BAO/MailingJob.php
+++ b/CRM/Mailing/BAO/MailingJob.php
@@ -123,8 +123,8 @@ class CRM_Mailing_BAO_MailingJob extends CRM_Mailing_DAO_MailingJob {
          AND       j.end_date IS null ) )
          AND (j.job_type = 'child')
          AND   {$mailingACL}
-      ORDER BY j.mailing_id,
-           j.id
+      ORDER BY j.scheduled_date ASC,
+        j.mailing_id
       ";
 
       $job->query($query);
-- 
2.25.1