This document briefs about the program object implementation for one of the interesting activities which I did past few days.
To give an introduction about program object – In BusinessObjects we are allowed to execute the external scripts such as batch file, VB script, Java script or even a java code itself using program objects. The advantage is even you can schedule them to run periodically as your BusinessObjects report.We have planned to automate some of our regular housekeeping activities using program objects. Please refer my blog here for some of the list of housekeeping activities. http://scn.sap.com/community/bi-platform/blog/2012/10/22/businessobjects-monitoring-and-housekeeping-activities
One of such activity is archiving the log files created in BusinessObjects installation folders periodically every week. This is to ensure that the Installation folder size is optimal and manageable. The idea here is to create a program object which take care of the archival process and schedule this to run at regular interval. Let me brief what I did for my requirement.
Size of our Logging folder within BusinessObjects Installation directory keep on increasing on daily basis. We do have a necessity to keep the old log files for at least last two months (retention period). Archived log should not be maintained in Installation folder to keep the size of Installation drive optimum. So we planned to move the old log files from Installation Log folder to a Log backup directory somewhere in a shared drive every 2 weeks for possible future environment investigation.Any log file files that are aged more than 60 days will be deleted permanently from the Log files stored in Shared drive.
Below steps will give you the detailed steps to implement the program objects.
1. Initial Setup in CMC
Make sure the credential you give above has appropriate rights (Logon,Execute) at Operating system level.
2. Adding Program Object
Scheduling Program Object
Adding program Objects logon parameter (OS level where script has to run) if you want to give specifically. If not this details will be taken from Initial CMC Program Object configuration.
Finally this would be my result and what I required
Please note Program Objects will be handled by Adaptive Job Servers. Hope you find this interesting.