Answers.Body: <p>We found that applying this line's change from this PR to the mosaico extension solved our problem: <a href="https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/pull/182/files#diff-d8205fe762b98a885815f3d4bb175886R294" rel="nofollow noreferrer">https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/pull/182/files#diff-d8205fe762b98a885815f3d4bb175886R294</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-15T15:00:29.307Z
Answers.LastActivityDate: 2018-03-15T15:00:29.307Z
Answers.UserDisplayName: Joe Murray
Body: <p>On Civi 4.7.27 send first large mailing to 12733 emails through SparkPost, only some were delivered (about 900), and the job says it has not completed. Unfortunately, it is 16h later and the Send Schedule Mailings (Entity: job Action: process_mailing) keeps succeeding every 5 minutes. </p>
  
  <p>The settings were default, so the job attempted to send all 13k emails at once, which I confirmed by finding one child job still in state of 'Running' in the civicrm_mailing_job table with 0 offset and all mailings included.</p>
  
  <p>My suspicion is that the job timed out.</p>
  
  <p>How can I invoke a job that will complete the sending? Can I determine from one of the tables which emails have been sent to, and can I restart from there?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-14T17:07:52.483Z
Comments.Text: How have you tuned your Mailer settings ? Have you tried to decrease the Mailer Batch Limit ? (I had similar issues with big mails (up to 1 Mb))
Comments.UserDisplayName: Jacques-Marie Moranne
Tags: <civimail><mailing><scheduled-job>
Title: Send Schedule Mailings job succeeds but scheduled mailing not completely sent
ThreadText: # Send Schedule Mailings job succeeds but scheduled mailing not completely sent
  
  (Asked by: username_0 on 2018-03-07)
  
  On Civi 4.7.27 send first large mailing to 12733 emails through SparkPost, only some were delivered (about 900), and the job says it has not completed. Unfortunately, it is 16h later and the Send Schedule Mailings (Entity: job Action: process\_mailing) keeps succeeding every 5 minutes.
  
  The settings were default, so the job attempted to send all 13k emails at once, which I confirmed by finding one child job still in state of 'Running' in the civicrm\_mailing\_job table with 0 offset and all mailings included.
  
  My suspicion is that the job timed out.
  
  How can I invoke a job that will complete the sending? Can I determine from one of the tables which emails have been sent to, and can I restart from there?
  
  **Tags:** civimail, mailing, scheduled-job
  
  > **Comments:**
  > **username_1**: How have you tuned your Mailer settings ? Have you tried to decrease the Mailer Batch Limit ? (I had similar issues with big mails (up to 1 Mb))  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2018-03-15. Score: 3 | Accepted answer
  
  We found that applying this line's change from this PR to the mosaico extension solved our problem: <https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/pull/182/files#diff-d8205fe762b98a885815f3d4bb175886R294>
  
  
  ---
  
  