Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Tracking OBIEE 12C(12.2.1.4) Agents

Received Response
381
Views
5
Comments
deniska
deniska Rank 5 - Community Champion
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

Hi.

I want to track most of available info about Agents in OBI (by whom created, Agents params, execution of Agents etc.) but I don't know how...

There is a great Usage Tracking Tool for user activity and queries and I'd like to get something like that for Agents. Is that possible?

I've read about S_Nq_Job tables for 10g/11g but nothing for 12c.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    The tables didn't move. Still the S_NQ_JOB and other few tables there around.

    Just keep in mind that most of the attributes of agents are still just inside the agent itself (the XML file saved in the catalog).

  • deniska
    deniska Rank 5 - Community Champion

    But I havent found manual(and scripts) for 12c to install and activate it.

    Would you tell how to do it?

  • Gianni Ceresa
    Gianni Ceresa Mod

    The S_NQ_JOB are created by default when you run the RCU to install the product. There isn't anything to configure, they exists. Look into your BIPLATFORM schema in the database.

  • deniska
    deniska Rank 5 - Community Champion

    Thanks a lot. I thought you have to create it from script(as well as S_NQ_AQQT) and activate in config file...

    I created Agent, executed it, received email with analysis and got SUCCESSFUL message in BI BUT S_NQ_ERR_MSG contains records with delete_flg=0. I think it is an "OK" but can I read about possible values anywhere

  • Gianni Ceresa
    Gianni Ceresa Mod

    S_NQ_ERR_MSG doesn't mean all it contains is an error, it could just be a log.