How can I see all the reports scheduled, when they are scheduled to run, and who scheduled them.

Question

I need to see all the reports scheduled, when they are scheduled to run, and who scheduled them.

A database query would do fine, I just need to find the right table/s and report_schedules does not seem to have information on the last run, just the next one.

For some reason on some Wednesday mornings, not all, at around the same time the application server load spikes ridiculously high.

(For example this morning's load average was: 60.00, 52.30, 31.22)

I am trying to figure out what may be causing this spike. The only suspicious thing I see is an unusually large number of httpd processes running.

thanks,

FrancescaS

Francesca Shiekh · Accepted Answer

Hello Francesca,

HaPHPy New Year !

You can find probably all of your information and inspiration in this file modules/Reports/schedule/ReportSchedule.php

The reports are scheduled from file process_queue.php available in the root directory of Sugar which firstly disable report for disable user and check which are the next reports to send.

Best regards,