Forum Stats

  • 3,751,231 Users
  • 2,250,334 Discussions
  • 7,867,350 Comments

Discussions

Enterprise Manager 13c - query used in metric

User_LG3TJ
User_LG3TJ Member Posts: 1 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:
User_LG3TJ

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

    User_LG3TJ