Enh 31248426 - OAC-OM NEEDS JOB MANAGER SIMILAR TOOL TO MANAGE AGENTS IN OAC SOURCING ONPREM ORACLE

Marcelo Finkielsztein

Organization Name

Postmedia Network

Description

Enh 31248426 - OAC-OM NEEDS JOB MANAGER SIMILAR TOOL TO MANAGE AGENTS IN OAC SOURCING ONPREM ORACLE DATABASE

I believe i had entered this as an idea before, but i cannot find it now.   Repeating just in case:

 

1) Using On Premise OBIEE 11, we were able to use JOB MANAGER to handle agents, monitor their execution, analyze execution errors, etc.

2) Using On Premise OBIEE 11, we were able to query these tables:
* S_NQ_ERR_MSG
* S_NQ_JOB
* S_NQ_JOB_PARAM
* S_NQ_INSTANCE
and create our own analyses on them.  (for instance,  "display all agents that have failed in the last 48 hours, showing owner and error message")

We expect to be able to keep this functionalities in OAC.

Please implement a way to have OAC write into these tables, either on an on-premise oracle DB via RDG, or to an ADW database.

TIA,
Marcelo F

 

Use Case and Business Need

please see description above

Original Idea Number: 9fe7ded760

vkm

This is required to have an overview of all the jobs that are scheduled to run by the users

Prashanth Asani

This functionality in OAC is required to do reporting against the Agent tables to find the status and other agent details.