1 person found this helpful
Have you checked the scheduler log files?
There are also the scheduler DB tables in the RCU schema - S_NQ_SCHED, S_NQ_JOBS,S_NQ_JOB_PARAM, S_NQ_INSTANCE
Thirdly, you can look at the Job Manager client tool
I would also use a 'real' e-mail account, then you can have an administrator or programmatic equivalent check the inbox for notifications from e-mail failures, this can be a useful extra check for when people leave the company and the BI team are the last to know...
On top of what Joel said, you can take the problem from the other side (outside OBIEE): your email are delivered via a mail server (SMTP), so look at the logs of your SMTP and you must find out exactly which email has been sent and to whom.
But that will not give me report information .
All depends on how the report is sent and the amount of logs the SMTP has (like attachment names, subject etc.), a lot less friendly but just another option on top of others.
The easiest is obviously what Joel said: it's generated by OBIEE, so of course it has the best links with OBIEE content.
Thanks all .. I'm trying thee stuffs and will update you.
Okay So I checked all these and I could not find the information what I am looking .
The tables don't have any email address .
<OBIEE_HOME>/user_projects/domains/bi/servers/obisch1/logs doesn't exist.
My Job Manager don't have any agents
Didn't realise that you were on 11g.
Very strange that you don't have any jobs in your Job Manager. Also, you said "Okay So I checked all these and I could not find the information what I am looking ." what exactly did you find?
Thanks ..but what i found is not the what I was looking for ..I am looking to find on how I can find the email recipients to whom the agent has delivered the report or list of all the email recipients that agent is configured to deliver the reports .
Can you check in your system/table if its there .
Joel.. if you have a obiee instance , can you check there please ..
the scheduler log has this info..
[2017-02-12T06:47:11.000-08:00] [OracleBISchedulerComponent] [ERROR:1]   [ecid: 0jdjdof_ltijdoiewjfnewiojqerfmnoj00019k020020203t,0:3:55 [tid: d38] AgentID: /users/john_smith/Untitled1234 [[ Invalid subscribers skipped:
this is different .. are you sure that we can check the list of the recipients configured with agent from logs or tables? have you seen those info yourself in those logs and tables?
this is the location in 11g.
Sorry to burst your bubble here, but ....HOW is that the right answer?
a) "SampleAppLite" - why develop in the SapmeAppLite catalog??
b) Just conceptually how is a physical catalog path an answer to your initial question? How would that solve the issue of anyone?
Marking this as "correct" is supremely misleading for other forum users!