Report on overall job success grouped by day

[kahlep]

Reporting on the success of executed jobs would help to identify the most important issues to fix.

Grouping by day can show change in success rates after server updates.

Other interesting information to group by would be

• versions of modules that ran the jobs
• Exception class and message of failed jobs

Example query to start from:

SELECT
    COUNT(jobid),
    state,
    TO_CHAR(created,'YY') year,
    TO_CHAR(created,'MM') month,
    TO_CHAR(created,'DD') day
FROM
    jobs
WHERE
    (
        state = 'FINISHED'
        OR    state = 'FAILED'
    )
    AND   created IS NOT NULL
GROUP BY
    state,
    TO_CHAR(created,'YY'),
    TO_CHAR(created,'MM'),
    TO_CHAR(created,'DD')
ORDER BY
    year DESC,
    month DESC,
    day DESC