CiviCRM Community Forums (archive)

Hi,

I have created a report and want to schedule it to run once a month. However this does not seem possible with the built in scheduler. So my next option is to run the report from an external cron. In the attached is my job. When I run it from the web interface it runs fine with no issues and the emails arrove as I expect. However when I run it with curl (see red text at bottom of image) I:

• Don't get any error message
• There is nothing in the CiviCRM log for the job showing the CURL run (only the web ones previously run)
• Naturally the emails for the report do not arrive

So my questions are:

1) Do I have the correct syntax to run the report?
2) Having triple checked the site key and username/password (the overall invocation of CiviCRM is working) if they are not correct (why?) do I get no error?
3) How do I work out what the issue is here with the cron job dying silently? I have read http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs#ManagingScheduledJobs-Command-lineSyntaxforRunningJobs and the two threads it mentions but there is nothing there for me.

As an aside some suggestions for future releases of CiviCRM:

1) In the cron job edit screen show the URL that could be used to invoke this particular job
2) Optionally fill the username/password/sitekey for 1) above assuming the user is logged in as a Super Admin and has the necessary priviledges. Saves having to hunt through API etc

Hoping someone can shed some light on my questions.

Are the versions that display in your profile correct, Joomla 1.7.x and Civi 4.0.7?  Those are very old versions so if it is it may be tough to answer but that is the first crucial piece of information.

Have you tried running the CURL for all jobs instead of just the specific one?  That would be the same URL except without the instanceid and job strings at the end.