BOE 3.1 - Script to start/stop servers

We are using Business Objects Enterprise 3.1 - Running on Windows Server 2008 R2 v6.1 Please keep in mind i am not super technical...

I need help in finding out how to write a script (or some type of program) that will stop the CrystalReportsJobServer at a set time (midnight) and then one that will start the CrystalReportsJobServer once a file watch has completed.

Any assistance or even pointing me to some documentation would be great!

Susan M
mcsusanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Why do you need to stop and start it?

mlmcc
0
mcsusanAuthor Commented:
We use Epic - an electronic medical record system.  The database the reports on BOE run against is called Clarity.  The Clarity tables are populated via an extract from Epic that runs from Midnight to 3am ish.  We have been having multiple issues with our extracts and they are not finishing before our first scheduled reports start running. Part of the extract issue is people running reports during that midnight to 3am time frame.  We need to stop/disable the CrystalReportsJobServer during the extract time so no one can run reports against BOE.  Then we want the CrystalReportJobServer to restart/resume once the extracts have completed.

Does that help?
0
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Unfortunately, the job server isn't exposed as a direct Windows Service (assuming a Windows server installation) with 3.1.  The only exposed service in Windows is the Server Intelligence Agent, which runs all of the various internal servers.  So, you'd have to create a script using the SDK, which is more complex.

Do you need to only stop the job servers, thereby allowing users to still access the system for activities like viewing historic instances?  Presumably, you don't want users running reports on demand during this time period since they'll have the same issues as those scheduling reports.  Would simply stopping the SIA--effectively shutting down Enterprise--work, or would you like to leave Enterprise up, but not allow users to run or schedule reports?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

mcsusanAuthor Commented:
We need to leave Enterprise up, allowing users to access historical instances, but not allow users to run or schedule reports.

Our users work 24/7.
0
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
You (your company) should have access to the SAP Service Marketplace.  Please review the following KB Note and it should help you with the commands, which can be integrated into a .bat file:

http://service.sap.com/sap/support/notes/1286926
0
mcsusanAuthor Commented:
The link doesnt work for me.
0
mcsusanAuthor Commented:
i have access to the SAP help & support but can not find that note.
0
mlmccCommented:
TO get to that link you need a SQP Passport which is not required for access to a SAP Help

This may be enough to get the information you need.

From the above link (SAP)
To see the commands available
Open a command window (CMD)
run ccm.exe /help

I believe the commands you want are

"C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\ccm.exe" -enable machine1.CrystalReportsJobServer -cms machine1:6500 -username SysAdmin -password 35%bC5@5 -authentication secLDAP

"C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\ccm.exe" -disable machine1.CrystalReportsJobServer -cms machine1:6500 -username SysAdmin -password 35%bC5@5 -authentication secLDAP

Above commands courtesy of
http://service.sap.com/sap/support/notes/1286926 

Kurt - If the commands I provided are incorrect, please correct them

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Technically, the cleanest way to do this is to disable the services first, then stop them.  To bring them back up, you'd start them then enable them.

In this case, this only disables the servers.  There are additional commands for actually stopping and restarting them.

Also, you'll need to replace the type of authentication with your specified method (such as using secEnterprise or secWinAD for a user account that has the necessary permissions to perform those duties in the CMC), change the installation folder patch, etc...

If you just copy/paste that url into a browser window you should immediately be prompted for a user and password in order to access the content. Otherwise, you can manually go to service.sap.com and search for note 1286926 under notes after you login.
0
mlmccCommented:
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SAP

From novice to tech pro — start learning today.