HOW TO RUN BODS JOB THROUGH UNIX SCRIPT

[Former Member]

Dear Experts

Please provide me the way how to call a job by a script .

I have used Export Execution Command as recommended by below links

http://scn.sap.com/docs/DOC-34648

http://scn.sap.com/community/data-services/blog/2012/08/22/sap-bods--running-scheduling-bods-jobs-fr...

But I am not able to locate .sh  file in unix server .

This is required to call a job after completion of parent job.

Thanks

Anupam

[DayaJha · Accepted solution]

When you create "SHELL Script" of BODS Jobs using export execution command in SAP Business Objects Data Services management console it will geerate the shell script in log directory (Job Server log directory).

Then from there you can place it any location, but if you want to execute from any specaific location you have to set the environment varaiable for  that user (Add al_env.sh information in user Profile).

Thanks,

Daya

[Former Member · Accepted solution]

Dear Daya,

Can you help me to locate log directory (Job Server log directory).

I am not able to find the directory .

Thanks

Anupam

[DayaJha · Accepted solution]

Path for BODS Job Server Log

Default path:

%LINK_DIR%\log\<Job Server Name>

Thanks,

Daya

[Former Member · Accepted solution]

Dear Daya,

Thanks a lot , I found the file .

Please let me know how to run it.

I have used below script .

Print('Trigger Job1');

Print(exec('/bods_app/IPS/dataservices/log/T1.sh','',8));

Print('Trigger Job2');

Print(exec('/bods_app/IPS/dataservices/log/JOB_ALL_CRM_VIEWS_TRUNCATE_LOAD.sh','',8));

[DayaJha · Accepted solution]

Following are the steps required for running the BODS Job SHELL script:

• Check al_env.sh file information is available in environmental variable
• Then only you can execute from any location
  • For e.g: ./Job_SAMPLE.SH

Thanks,

Daya

[Former Member · Accepted solution]

Dear Daya ,

I found file al_env.sh ,

Do I need to customize or edit this file.

I am getting below error while executing shell script .

/AL_RWJobLauncher: error while loading shared libraries: libebus.so.3.3.2.7: cannot open shared object file: No such file or directory.

Thanks

Anupam

[DayaJha · Accepted solution]

You have to add below parameter in user environmental variable

  . $LINK_DIR/bin/al_env.sh

If you want to execute the SHELL script from outside the LINK_DIR (Data Services directory)

Thanks,

Daya

[Former Member · Accepted solution]

Thanks Daya,

Jobs are running but visible in console ..

I have few more doubts

1. How can we monitor running jobs ?

2. How can we export these scripts to development to UAT and Production as /Job_SAMPLE.SH contains development environment details .

Thnaks

[DayaJha · Accepted solution]

You can check the status in "SAP Business Objects Data Services management Console", Below are the steps

• Login in SAP Business Objects Data Services management Console
• Click on Batch Job
• Select the local repository
• Then check your Job Execution status from there

For your second query there are two ways one is do the same activity what you have done in DEV.

below are the steps

• Login in SAP Business Objects Data Services management Console and export the Jobs using export execution command from batch job
• SHELL Scripts will be exported in Job Server Log
• Move that SHELL script as per your location
• Update the User environment variable same as DEV only difference is SID is changed

Thanks,
Daya