Name: Dba Jobs check
Platform: Oracle
Category: Availability
Description: Detecting failed scheduled jobs in old style dba_jobs.
Long description: The BROKEN column in the Oracle dictionary view DBA_JOBS is used to detect jobs that have failed.
Version: 2.3
Default schedule: 5,15,25,35,45,55 * * *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & _priv_read_dba_jobs = ‘1’
Name Default value Description
ignore job id Job ID from job column in dba_jobs excluded from being checked (comma separated).
return status on failed job 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when a job have status FAILED (and are not in “ignore job names” list).
last run 01.03.2010 00:00 The last date the dbWatch Job scheduling check was run. Only jobs run after this date will be checked (column actual_start_date in the dba_scheduler_job_run_details view). Value format DD.MM.YYYY HH24:MI

← Database uptime / DBMS uptime →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment