oracle aide

July 6, 2013

OBIEE iBots: status and exit codes in the S_NQ_INSTANCE table

Filed under: Uncategorized — Tags: — oracleaide @ 11:05 pm

The S_NQ_JOB contains jobs definitions. 

The S_NQ_INSTANCE table contains one row for each job run.

Two columns in S_NQ_INSTANCE shed light on what happens with an iBot.
1. EXIT_CODE: number of e-mails sent by an iBot job, after the job is completed (probably after a commit)/
2. STATUS :
0 – Completed
1 – Running
2 – Failed
3 – Cancelled
4  – Timed Out

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: