Hi Team,

We are migrating from OBIEE 11g version to OACS Gen2. There is functionality in On-Prem OBIEE platform which is as follows.

1. There is a Autosys tool (Scheduling engine) which calls a script at particular time (or based on Batch Load success) placed on OBIEE Server with some parameter (for ex. LDW below)

/opt/app/mi/obiee/$OBIEE_ENV/bin/run_ibots_by_app.sh LDW

2. This script logs into the BIPLATFORM Schema related to OBIEE Server and pulls the Agents list from S_NQ_JOB and S_NQ_JOB_PARAM tables (using below SQL) and then using run_ibot.sh script within loop, triggers all the agents one by one.

If there are 10 Agents containing same description, all will be fetched using sql and trigger one by one using loop.

SQL -->
select JOB_ID AS IBOT_FULL_PATH from (SELECT jobp.*, rank () over (partition by name order by job.job_id desc) rn FROM S_NQ_JOB job, S_NQ_JOB_PARAM jobp WHERE job.JOB_ID = jobp.JOB_ID AND RELATIVE_ORDER = 1 AND UPPER (job.DESC_TEXT) LIKE '%${OBIEE_APP_TO_RUN}_AUTO_RUN_AFTER_BATCH%')where rn=1;

In above sql, OBIEE_APP_TO_RUN is the parameter which is being passed in 1. step and _AUTO_RUN_AFTER_BATCH is part of the description mentioned in Agent.

We would like to achieve the same functionality in OACS Gen2 but having below challenges.

Question 1: There is no mechanism where we can pull in all Active Agents information basis on description associated with the Agent.
Question 2: Is there any way we can schedule the script placed on object store and from we can trigger the agents automatically.

Thanks,

Gaurav