pj_jobmon allows database administrators to easily follow database operations and check out how one or more functions behave.
When dealing with a job failure or other error, pj_jobmon logs everything to that point and does not miss messages or details that might help the developer in fixing the issue.
This extension can be a real time saver in debugging problematic jobs or for testing new extensions or updates.
· PostgreSQL 9.1 or higher
What's New in This Release: [ read full changelog ]
· Critical Bug Fix: Version 1.0 accidentally removed the creation of the trigger on the job_log table so that failing jobs would never cause check_job_status() to report a failed job. Jobs that were configured to run within a certain time period were still monitored for. This only affects new installations of pg_jobmon since 1.0. If you've upgraded from a previous version, the trigger is still working properly.
· Redesigned check_job_status() to return more detailed, and more easily filtered data on the current status of running jobs. Please check how your monitoring software used this function to ensure it can handle the new output format properly. Each problem job is returned in its own row instead of all results being returned in a single row. If a single row is still desired, the highest alert level job in alphabetical order of job_name is always returned first, so a LIMIT 1 can be used as an easy solution. More advanced filtering is now possible, though. See the updated pg_jobmon.md doc for some examples.
· Wrote pgTAP tests and some other custom tests to better validate future changes.