Automate Cache purge for OBIEE 12c.

-- create a shell script file

#!/bin/bash

TODAY=$(date)
HOST=$(hostname)
echo "-----------------------------------------------------------------"
echo "Date: $TODAY                     Host: $HOST"
echo "-----------------------------------------------------------------"

/test1ap/obiee/fmw/Middleware_12c/user_projects/domains/bi12c/bitools/bin/nqcmd.sh -d AnalyticsWeb -u vikas -p Welcome1  -s /test1ap/obiee/obiadmin/scripts/purge_cache.txt

echo "Please find attached Cache purge log from Test server." |mailx -s "BI Test server Cache purge status." -a "/test1ap/obiee/obiapp/scripts/BIEE_test1_purge_cache.log"  vikas@test.com

-- Create a txt file (purge_cache.txt) for the command for the purge cache.

call SAPurgeAllCache()

-- provide 777 permission to all of the 2 files (sh and txt file).
-- schedule cron job.

/test1ap/obiee/obiapp/scripts/purge_cache.sh &> /test1ap/obiee/obiapp/scripts/BIEE_test1_purge_cache.log