Executing a job by another job in BODS 4.1 using simple script

Step1:

In DATA SERVICES MANAGEMENT CONSOLE goto Batch Job Configuration Tab and click on Export Execution Command.

This will create a .bat file with the job name (Job_TBS.bat) in the following path:

D:\Program Files (x86)\SAP BusinessObjects\Data Services\Common\log\

Step2:

Use the below script to check whether the respective .bat file exist in the below path.

exec(‘cmd’,’dir “D:\\Program Files (x86)\SAP BusinessObjects\Data Services\Common\log\”*>\\D:\\file.txt’);

Step3:

Create a new job (J_Scheduling) to trigger the job which needs to be executed (Job_TBS).

Use the below script to trigger the job.

exec(‘cmd’,’D:\\”Program Files (x86)”\”SAP BusinessObjects”\”Data Services”\Common\log\Job_TBS.bat’);

Now the job J_Scheduling will trigger the job Job_TBS using simple script 🙂