Find the Status of the iBot Develiry through Back-End Table

The scheduler tables are used by Oracle Delivers and are populated with information from the Scheduler jobs. The tables are:

Table Name	Table Description
S_NQ_JOB	This table is used by Scheduler to store information about scheduled jobs
S_NQ_INSTANCE	The S_NQ_INSTANCE table stores information about scheduled job instances
S_NQ_ERR_MSG	This table stores error messages for Scheduler job instances that do not complete successfully.
S_NQ_JOB_PARAM	This table holds information about Scheduler job parameters for scheduled jobs

We can check STATUS from S_NQ_INSTANCE table, which can have different values....

STATUS =0 Completed
STATUS =1 Running
STATUS =2 Failed
STATUS =3 Cancelled
STATUS =5 Timedout

Location of the Log

OracleBI_Home\server\Log\iBots

Following query will give us a list of ibots failing since previous day.  

select STRING_AGG( DISTINCT(J.name)) AS FAILING_IBOTS
from s_nq_job j, 
s_nq_instance i
where j.job_id = i.job_id
and i.status in (2,4)
and (i.begin_ts - 8/24) > trunc(sysdate) - 1;

-Asifkhan P.