MicroStrategy Command Manager Stored procedure

//stored procedure to update project configuration.


 String updateProjectCache="";

String connectQuery= ("CONNECT SERVER \"" +
 server + "\" USER \"" + user + "\" PASSWORD \"" + password + "\" PORT 34952;");

execute(connectQuery);

ResultSet projectRS = executeCapture("LIST PROJECTS;" );

 projectRS.moveFirst();

while (!projectRS.isEof() )
{
printOut("Applying Evolv Project Configuration On Project" +                projectRS.getFieldValueString(DisplayPropertyEnum.NAME));
 if (projectRS.getFieldValueString(2).equals("Loaded"))
{
updateProjectCache="ALTER PROJECT CONFIGURATION " + "MAXNOREPORTRESULTROWS 100000 " +
"MAXNOELEMROWS 100000 " + "MAXNOINTRESULTROWS 100000 " +
 "MAXJOBSUSERACCT 1000 " +
 "MAXJOBSUSERSESSION 1000 " +
 "MAXEXECJOBSUSER 1000 " +
"MAXJOBSPROJECT 1000 " +
 "MAXUSERSESSIONSPROJECT 500 " +
 "IN PROJECT \"" +
 projectRS.getFieldValueString(DisplayPropertyEnum.NAME) + "\"; "; execute(updateProjectCache);
}
 projectRS.moveNext();
 }//end of project
execute("DISCONNECT SERVER;");

MicroStrategy start/stop command

MicroStrategy Linus command to stop and start linux server:
location from where to run following command: ~installationDirectory/Home/bin

Commands:
./mstrctl -s IntelligenceServer stop
./mstrctl -s IntelligenceServer start
./mstrctl -s IntelligenceServer term
./mstrctl -s IntelligenceServer gs

Oracle export db batch file

@ECHO OFF


set ORACLE_SID=ORCL

for /f "tokens=1-4 delims=/ " %%a in ('date /t') do (
set DATE=%%c-%%b-%%d
set Month=%%b
set Year=%%d)
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
set hours=%%a
set minutes=%%b
set ampm=%%c
)

if {%ampm%}=={AM} if {%hours%}=={12} set hours=00
if {%ampm%}=={PM} (
for /f "delims=0 tokens=*" %%a in ("%hours%") do set hours=%%a
set /a hours+= 12
)

if %Month%==01 set Month=JAN
if %Month%==02 set Month=FEB
if %Month%==03 set Month=MAR
if %Month%==04 set Month=APR
if %Month%==05 set Month=MAY
if %Month%==06 set Month=JUN
if %Month%==07 set Month=JUL
if %Month%==08 set Month=AUG
if %Month%==09 set Month=SEP
if %Month%==10 set Month=OCT
if %Month%==11 set Month=NOV
if %Month%==12 set Month=DEC

set devDBBackupPath=\DEV\MSTR_VERSION_9_0_1
set devDB=mstrmetadata

if NOT exist %Month%-%Year%\%devDBBackupPath% (
mkdir %Month%-%Year%\%devDBBackupPath%
 )
@ECHO ---------------------------------------------------
@ECHO Exporting MSTR VERSION 9.0.1 METADATA ( %devDB% ) ............
@ECHO ---------------------------------------------------

set devDBBackupPath=%Month%-%Year%\%devDBBackupPath%

exp %devDB%/str0ng@%ORACLE_SID% file=%devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.dmp log=%devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.log

zip -jj .\%devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.zip %devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.*

DEL %devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.dmp
DEL %devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.log



@ECHO ---------------------------------------------------
@ECHO %devDB% Exported successfully
@ECHO ---------------------------------------------------