 |
| ||||
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.
Requirements:
· PostgreSQL 9.1 or higher
What's New in This Release: [ read full changelog ]
· fail_job() can now take an optional second argument to set the final alert code level that the job should fail with in the job_log table. Allows jobs to fail with level 2 (WARNING) instead of only level 3 (CRITICAL). Default is level 3.
· New check_job_status() function that doesn't require an argument. Will automatically get longest threshold interval from job_check_config table if it exists and use that. Recommend using only this version of fuction from now on.
· check_job_status(interval) will now throw an exception if you pass an interval that is shorter than the longest job period that is being monitored. If nothing is set in the config table, interval doesn't matter, so will just run normally checking for 3 consecutive failures. Changed documentation to only mention the no-argument version since that's the safest/easiest way to use it.
Via: pg_jobmon 1.0.0
No comments:
Post a Comment