Oracle Analytics and AI

Vijay Nathan

Hi Everyone,

Is possible to set Month End Agents in OBIEE 12c. Which means On every month end I would like to trigger an auto-mail to users. Is this possible in OBIEE 12c Agent ?

When I select date and All months in Agents, it shows validation message.

Thanks in advance.

Gianni Ceresa

Hi,

You get a message because if you select 31 and all the months there are many months where the 31 doesn't exist (if you select 28 you don't get the warning anymore as all the months have the 28).

So there isn't a "checkbox" way to set an agent to run at the end of every month ...

Do you really want to run it the last day of the month or do you want to send out the data of the month you just closed? Maybe running the 1st day of the month is an acceptable alternative?

Or you can setup your agent to run daily but adding a condition, the condition would be really simple and it check if CURRENT_DATE is the last day of the month (of course your agent will try to run 353 times being stopped by the conditions and only 12 times something will be done, but that's the price to pay ...).

You can of course make 3 agents schedules for the 31, 30 and 28 based on the months (but remember sometime February has 29, so ... still doesn't work by itself )