Hello,
I have noticed, that NAV is reporting jobs as overdue, even though a
job end with success. I believe the problem is caused by trigger
trim_old_ipdevpoll_job_log_entries, which should delete the old jobs
from the ipdevpoll_job_log table.
DELETE FROM ipdevpoll_job_log WHERE id IN (SELECT id FROM
ipdevpoll_job_log WHERE job_name=NEW.job_name AND netboxid=NEW.netboxid
ORDER BY end_time ASC OFFSET 100);
When there are 100 log entries for a job in the nav database the trigger
will delete the newest logged job instead of oldest one. I believe, that
the ORDER BY clause should be DESC not ASC.
Regards,
M.