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 🙂
Good One..!!
Thanks for Sharing 🙂
useful tips.
Very Good document
hi,
my requirement is to generate a .bat file.
but when i go to management console and export , it generates a .txt file and it is also a password protected. we are not even able to open it.
this was the message that was showed up.
Export was successful.Password file created on Job Server mxtestdev00000:3500, at /maxdsq/dataservices/conf/BODS_dev_repo1.txt.
can anyone suggest?
if the called job (Job_TBS) has global variable, how i can pass these variables from the master job (J_Scheduling) to the called job (Job_TBS)??
Useful steps- thanks