The oraEM4JobAlertTable describes changes in the status of either a Job or a Corrective Action that is running as part of the Oracle Enterprise Manager Job system.
Table A-13 lists the variables of the oraEM4JobAlertTable and their corresponding Object IDs.
Table A-13 oraEM4JobAlertTable Variables and Corresponding Object IDs
| Variable Name | Object ID |
|---|---|
|
oraEM4JobAlertJobName |
1.3.6.1.4.1.111.15.1.2.1.2.1 |
|
oraEM4JobAlertJobOwner |
1.3.6.1.4.1.111.15.1.2.1.3.1 |
|
oraEM4JobAlertJobType |
1.3.6.1.4.1.111.15.1.2.1.4.1 |
|
oraEM4JobAlertJobStatus |
1.3.6.1.4.1.111.15.1.2.1.5.1 |
|
oraEM4JobAlertTargets |
1.3.6.1.4.1.111.15.1.2.1.6.1 |
|
oraEM4JobAlertTimeStamp |
1.3.6.1.4.1.111.15.1.2.1.7.1 |
|
oraEM4JobAlertRuleName |
1.3.6.1.4.1.111.15.1.2.1.8.1 |
|
oraEM4JobAlertRuleOwner |
1.3.6.1.4.1.111.15.1.2.1.9.1 |
|
oraEM4JobAlertMetricName |
1.3.6.1.4.1.111.15.1.2.1.10.1 |
|
oraEM4JobAlertMetricValue |
1.3.6.1.4.1.111.15.1.2.1.11.1 |
|
oraEM4JobAlertContext |
1.3.6.1.4.1.111.15.1.2.1.12.1 |
|
oraEM4JobAlertKeyName |
1.3.6.1.4.1.111.15.1.2.1.13.1 |
|
oraEM4JobAlertKeyValue |
1.3.6.1.4.1.111.15.1.2.1.14.1 |
|
oraEM4JobAlertSeverity |
1.3.6.1.4.1.111.15.1.2.1.15.1 |
|
oraEM4JobAlertJobId |
1.3.6.1.4.1.111.15.1.2.1.16.1 |
|
oraEM4JobAlertJobExecId |
1.3.6.1.4.1.111.15.1.2.1.17.1 |
A description of each of these variables follows.
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the job to which this alert applies.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The owner of the job to which this alert applies.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The type of the job to which this alert applies.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The status of the job to which this alert applies.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
A comma separated list of target to which this alert applies.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The time at which this job status changed causing this alert.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the notification rule that caused this notification.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The owner of the notification rule that caused this notification.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the metric or policy which caused the Corrective Action to run that caused this alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The value of the metric which caused the Corrective Action to run that caused this alert.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
A comma separated list of metric column names and values associated with the metric which caused the Corrective Action to run that caused this alert.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the key-column, if present, for the metric which caused the Corrective Action to run that generated this alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The value of the key-column, if present, for the metric which caused the Corrective Action to run that generated this alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The severity of the metric which caused the Corrective Action to run that generated this alert (for example, Critical).
Typical Range
Critical, warning, clear
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The job ID of the Enterprise Manager job that triggered this notification.
Typical Range
Not applicable
Significance
Very important