Does the Oracle agent collect or monitor dbms_jobs/dbms_scheduler, for example if the status is completed, broken or failed?
解决办法
The following rules are available to monitor jobs and their execution state:
DBO - Backup Job Failure This alarm is invoked when a backup has failed with an error. Backups are required in order to ensure the ability to restore the database, either prior to performing a point-in-time recovery or when a media failure has damaged a current datafile, control file, or archived log.
DBO - Job Broken This alarm is invoked when a job is either in "Broken" status or "Disabled" state (the sisabled state is relevant only for scheduler jobs). A job can become broken in one of the following conditions: In case of a scheduler job if the number of failed attempts to run exceeds a predefined threshold (max_failures attribute). Or in case of a dbms_job - if the status is explicitly set to "Broken" by the user (using the DBMS_JOB.BROKEN procedure), or has been marked as "Broken" by Oracle. In Oracle12c and higher versions this alarm can also be invoked at the PDB level.
DBO - Job Queue This alarm fires when the number of jobs that are waiting in the queue exceeds a defined threshold. Too few job queue process may lead to jobs delayed execution.
