Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c Component Status Notifications

Received Response
21
Views
5
Comments
User_MSQS7
User_MSQS7 Rank 6 - Analytics Lead

OBIEE Component Status Notifications Sending the Output Through Email

Environment : OBIEE 12.2.1.4.0, WINDOWS SERER 2016

Every day we have to send the status of the OBIEE 12c server by automated email. Is this possible to implement ?

fire the status.cmd on command prompt

once status exectued it will send by email to the listed emails

this could happens everyday on specific time

Answers

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Dear Experts,

    Please add your suggestions on above query.

    Thanks in advance

  • Joel
    Joel Rank 8 - Analytics Strategist

    You will have to script this. Quite simply, you need to execute the status.cmd script and your script should save the output from the status.cmd script and then you can send that output as an email. There are many examples on the web for email attachment automation.

  • User_MSQS7
    User_MSQS7 Rank 6 - Analytics Lead

    Dear Joel,

    Could you please share the links which are related to OBIEE ?. I tried with the task scheduler but its showing error.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Can you share what you have tried so far? This isn't really an OBIEE issue as such but more of a scripting issue. Have a quick look on Google for example scripts. You'll need to break it down to a portion of the script that captures the output of the status.cmd script which you'll pass into a file. You'll then need the next portion of your script to pick up this file created with the ouput and get that emailed out to whoever you need to get it. Again, there are sample scripts that you can find on Google to do this.

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru

    https://lmgtfy.com/?q=run+windows+command+task+scheduler

    It's a command. You can schedule it. Joel's here to help people. Not do the work they're paid to do for them for free.