Tuesday, April 24, 2012

OBIEE Agent Chaining does not update Scheduler tables

Just something of note. I stumble upon this from time to time and really don't appreciate it:

Agents being called by other Agents (i.e. agent chaining) will NOT write any execution information into S_NQ_JOB or S_NQ_INSTANCE.
So no LAST_RUNTIME_TS in S_NQ_JOB nor new line in S_NQ_INSTANCE.

Really not useful when using these tables as sources in the RPD to check and schedule execution of Agents! E.g. when did which agent run last with which result and should I run it again?

Cheers!

2 comments:

  1. We ran into same issue. Any work arounds for this ?
    Help appreciated -- Kevin

    ReplyDelete
  2. Hi Kevin,

    for the time being, there's no workaround for this. Chained agents do not write any log information into the tables.

    Cheers,
    Christian

    ReplyDelete