Mapping for MGMT_NOTIFY_JOB
Use the following map when gc$notif_event_payload .event_type=job_status_change'.
Table 6-11 Job Status Change Mapping
| MGMT_NOTIFY_JOB | 13c Notification Payload |
|---|---|
|
JOB_NAME |
gc$notif_source.source_name |
|
JOB_OWNER |
gc$notif_source.source_owner |
|
JOB_TYPE |
gc$notif_source.source_sub_type |
|
JOB_STATUS |
gc$notif_event_attr.value where its name=' execution_status_code' in gc$notif_event_attr_array. |
|
STATE_CHANGE_GUID |
gc$notif_event_attr.value where its name=' state_change_guid' in gc$notif_event_attr_array. |
|
JOB_GUID |
gc$notif_source.source_guid |
|
EXECUTION_ID |
gc$notif_event_attr.value where its name=' execution_id' in gc$notif_event_attr_array. |
|
TARGETS |
gc$notif_target.target_name, gc$notif_target.target_type |
|
RULE_OWNER |
gc$notif_msg_info.rule_owner |
|
RULE_NAME |
gc$notif_msg_info.ruleset_name |
|
OCCURRED_DATE |
gc$notif_event_payload. reported_date |