CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • New Mail in SCHEDULED state and not completing the JOB
Pages: [1]

Author Topic: New Mail in SCHEDULED state and not completing the JOB  (Read 1029 times)

tapash

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.1
  • PHP version: 5.3.3
New Mail in SCHEDULED state and not completing the JOB
November 07, 2013, 03:01:02 am
I have tried to send a bulk mail to the members but its not sending and remains on the SCHEDULED state (Screenshot). Can anyone help please? not sure how to sort this out.
« Last Edit: November 12, 2013, 03:09:46 am by tapash »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: New Mail in SCHEDULED state and not completing the JOB
November 07, 2013, 10:25:46 am
Is your CiviCRM cron job set up? And this job enabled?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

tapash

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.1
  • PHP version: 5.3.3
Re: New Mail in SCHEDULED state and not completing the JOB
November 08, 2013, 04:20:26 am
Quote from: Hershel on November 07, 2013, 10:25:46 am
Is your CiviCRM cron job set up? And this job enabled?

Thanks for reply. I have actually figured out how to do the schedule job Manually from ADMINISTER > SCHEDULE JOB > PROCESS SCHEDULED MAIL. If I execute that it sends email immediately no matter when it is scheduled.

But If I want to send it on a scheduled time and date how would I be able to do that Please?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: New Mail in SCHEDULED state and not completing the JOB
November 08, 2013, 04:37:58 am
First setup a cron job: http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

Second, for docs about CiviMail: http://book.civicrm.org/user/current/email/what-you-need-to-know/
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

tapash

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.1
  • PHP version: 5.3.3
Re: New Mail in SCHEDULED state and not completing the JOB
November 09, 2013, 02:29:24 am
Quote from: Hershel on November 08, 2013, 04:37:58 am
First setup a cron job: http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

Second, for docs about CiviMail: http://book.civicrm.org/user/current/email/what-you-need-to-know/

Thanks for this. Played with it since yesterday but still I am not able to send schedule emails via cronjob. here is what I have done...
* I Enabled SEND SCHEDULED MAILING job from system settings

* Added cronjob on my server
Code: [Select]
*/15 * * * * /usr/bin/php /srv/www/sites/all/modules/civicrm/bin/civimail.cronjob.php -s https://localhost -u Administrator -p mypassword -e Job -a execute
* I get this error message from cronjob
Code: [Select]
Could not open input file: /srv/www/iskconcdb/sites/all/modules/civicrm/bin/civimail.cronjob.php
Now I went to that directory and civimail.cronjob.php does not exist there!!!!

Am I missing something here.....?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: New Mail in SCHEDULED state and not completing the JOB
November 09, 2013, 09:37:46 am
Quote from: tapash on November 09, 2013, 02:29:24 am
Now I went to that directory and civimail.cronjob.php does not exist there!!!!

Am I missing something here.....?

Yes, you are. That file is in the Deprecated column on the page above. The file you need is:

civicrm/bin/cron.php
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: New Mail in SCHEDULED state and not completing the JOB
November 09, 2013, 11:25:15 am

i would recommend using cli.php and running the process_mailing job via that. I think this is documented in the wiki (if not, it should!)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

tapash

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.1
  • PHP version: 5.3.3
Re: New Mail in SCHEDULED state and not completing the JOB
November 11, 2013, 08:47:55 am
Quote from: Donald Lobo on November 09, 2013, 11:25:15 am

i would recommend using cli.php and running the process_mailing job via that. I think this is documented in the wiki (if not, it should!)

lobo

Thanks but it does not do anything. I just can't figure out for last few days how to make this work. Tried so many combinations still not working....

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: New Mail in SCHEDULED state and not completing the JOB
November 11, 2013, 09:26:42 am
Did you try loading the full URL for civicrm/bin/cron.php in the browser?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

tapash

  • I post occasionally
  • **
  • Posts: 56
  • Karma: 0
  • CiviCRM version: 4.4.13
  • CMS version: Drupal 7.34
  • MySQL version: 5.1
  • PHP version: 5.3.3
Re: New Mail in SCHEDULED state and not completing the JOB
November 11, 2013, 02:20:41 pm
Quote from: Hershel on November 11, 2013, 09:26:42 am
Did you try loading the full URL for civicrm/bin/cron.php in the browser?

i typed in browser

https://localhost/sites/all/modules/civicrm/bin/cron.php?name=administrator&pass=mypassword&key=946c9d75c4asite-key34bb4a2358bsitekey

 :D IT WORKED....
Now, how can I run this using crontab please?

UPDATE: managed to get it work crontab  with this script

*/15 * * * * php /srv/www/sites/all/modules/civicrm/bin/cli.php -u Administrator -p mypassword -e Job -a execute

Thank you all guys for helping :)
« Last Edit: November 12, 2013, 03:09:34 am by tapash »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • New Mail in SCHEDULED state and not completing the JOB

This forum was archived on 2017-11-26.