Sunday, August 13, 2017

Five Easy Steps of Creating Custom Hyperion Stop/Start Script on Windows Server


Enterprise Performance Management (EPM) comes with default start and stop scripts. Stopping and starting services is easy task in single server installation. But this task can be tedious in multi node environment.  System admin needs to go to each server and start/stop services. This may lead a need of master start/stop script which can communicate across servers and start/stop services.
By following this blog you should be able to create your own custom EPM start and stop script. I will also demonstrate the use of variables in batch scripts. 

  Open a notepad (I personally prefer notepad ++ or Ultra edit) start typing

Section #1 (descriptive section):- You may write any instructions about the script. This section does not execute any command


  Section #2 (Variable Section):- This section is being used to define variables. I have defined few variables such as
§  ScriptLogDir=C:\Oracle\AutomationFolder\Logs
§  SET ScriptLogFile="%ScriptLogDir%\StartServices.log"
§  SET HypServer_01= Server 1 name
§  SET HypServer_02= Server 2 name
§  SET HypServer_03 = Server 2 name



 Section #3 (Custom Log Location):- I also like to see the logs of my custom script. This section is being used to defined custom log location and back up with data stamp




 Section #4 (Windows Service Name):- I am using windows sc \\servername start "HyS9CALC_epmsystem1" command execute the Hyperion related service. You may also use “net start <service_name>".  SC can remotely login to another Windows server and execute services



Section #4 The final should look like this


Related helpful Url





No comments:

Post a Comment