Forum Stats

  • 3,782,912 Users
  • 2,254,708 Discussions
  • 7,880,223 Comments

Discussions

Enterprise Manager 13c - query used in metric

Dmytro Smenov
Dmytro Smenov Member Posts: 2 Green Ribbon
edited Jun 23, 2020 6:51AM in Enterprise Manager

Hello guys,

I got task - "send me the query used in this metric?"

It is related to Job with status "FAILED".

I find this failed Job but can't find with which query this metric detect this error.

Help me, please.

Thank you!

Tagged:
Dmytro Smenov

Answers

  • Venkata Thiruveedhi-Oracle
    Venkata Thiruveedhi-Oracle Posts: 590 Employee
    edited Jun 23, 2020 6:51AM

    Hi,

    Execution status for the FAILED_STATUS is 4;

    You can fetch from:

    mgmt_job

    </code><code class="plain sql" style="font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; background: none; color: #000000 !important;">mgmt_job_exec_summary

    </code><code class="plain sql" style="font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; background: none; color: #000000 !important;">mgmt_job_execution

    Best Regards,

    Venkat

    Dmytro Smenov