DBA jobs check

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’

Parameters
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

Feedback