search

salesagility / SuiteCRM

SuiteCRM - Open source CRM for the world
https://www.suitecrm.com
GNU Affero General Public License v3.0
4.46k stars 2.08k forks source link

Scheduler job log #8998

Open tsmgeek opened 3 years ago

tsmgeek commented 3 years ago

I am fairly sure that there was a way to view the Job Queue in an older version of CRM than 7.10, ie back in 7.8 etc.

Now that Job Log is shown per scheduler the actual columns are not really useful.

Job Name - not needed as you are viewing this within the scheduled job anyway
Job Status - ok
Job Resolution - missing, we should have this and a way to see the `message` field for it, if there are any errors
Percent Complete - not sure if this is being used but if not null then display it

Also can we have the old Job Queue back as well, this will also allow viewing other non-scheduled jobs in the queue. Ideally this would have all the filtering/columns in listview as other modules.

pgorod commented 3 years ago

Are you sure we had that? I just went looking for it in a 7.8.19 and couldn't find it.

And I don't remember seeing it, and I don't remember it being removed in the past years where I've been accompanying this project... do you remember where it was accessible from?

Mac-Rae commented 3 years ago

I don't remember seeing something like this. It did use to be different in how the reporting was handled tho. The subpanel kept a record of each run in a separate record however to save amassing a shed load of data the subpanel now only counts the records and gives the latest values.

The audits table for this record is off by default for the same reason also. What extra data are you looking for? Would it be something that could be achieved with additional debug logging do you think?

tsmgeek commented 3 years ago

Mabey I was just dreaming one day in the show, but im sure there was a way to view the Job Queue before, if not then my mistake.

The problem that spurred this was that one of our scheduled jobs was failing resolution=false but status=done we got no notification of the error until I went to the DB and looked at the Job Queue table. It would be good to monitor this in the UI somehow, maybe even flagging the Schedule with an error in the main list as well would be useful or even a Notify on failure flag which can then go to sysadmins etc.