My company highly utilizes agents for distribution of OBIEE reporting (via email). Currently, one of us 'admins' create the agent and put ourselves on the distribution list. We do this so that we know if the agent is successfully executing and the content of the email is looking the way that it should.
We are trying to figure out a better way of doing this. A way so that we don't simply have to track down each agent in the catalog and see if it succeeded and/or check our own emails to make sure the reporting is being distributed properly.
What we'd like to do -- we'd ideally like to have a dashboard that we could go to and easily see what agents have been ran at any given time of day (the agent name, maybe the time report the agent rant, what time they ran, and did they successfully execute).
In OBIEE 12c, does a utility/functionality already exist that would help us to achieve this?
If so, where could I begin investigating?
If not, would anyone have any good ideas as to how to begin doing such a thing?
(note -- I am not asking anyone to write any code or do this for me. I am only asking in case anyone might have ideas or might already be doing this and could offer advice as to where we could start looking)
