Job scheduling check

Name:	Job scheduling check
Platform:	Oracle
Category:	Availability
Description:	Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs that have failed.
Long description:	The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs that have failed.
Version:	3.02
Default schedule:	5,25,45 * * *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & ten_and_above = ‘1’

Parameters
Name	Default value	Description
ignore job names	AUTO_SPACE_ADVISOR_JOB,FGR$AUTOPURGE_JOB	Job names excluded from being checked (comma separated). You can use % (percent sign) to represent wild card characters.
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