Agent / BI Scheduler information are stored in OBIEE 11g tables

Configuring iBot in OBIEE 10G

OBIEE 10G - BI Scheduler / iBots are configured in RPD under Scheduler Configuration.

Under Scheduler tab > Database you will enter DB details to connect schema.

System table will be as below

For Storing Jobs                          : S_NQ_JOB

For Storing Instance Information          : S_NQ_INSTANCE

For Storing Error Messages         : S_NQ_ERR_MSG

For Storing Parameters               : S_NQ_JOB_PARAM

Configuring Agent in OBIEE 11G

In OBIEE 11g at the time of installation we install Repository Creation Utility (RCU), it will create BI Scheduler database called BIPlatform tables will be same as in 10G.

For Storing Jobs                          : S_NQ_JOB

For Storing Instance Information          : S_NQ_INSTANCE

For Storing Error Messages         : S_NQ_ERR_MSG

For Storing Parameters               : S_NQ_JOB_PARAM

Login to enterprise manager in and go deployment tab and then click on Scheduler tab.

Enter the information to connect with schema and your agent is configured now.

Configuring Mail Server:

Now go to Mail tab and enter mail server (SMTP) details, this server will be used to send reports through OBIEE Agent.