Skip to Content
Author's profile photo Former Member

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\

1.JPG

2.JPG

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).

3.JPG

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 🙂

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good One..!!

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing 🙂

      Author's profile photo Ramesh Murugan
      Ramesh Murugan

      useful tips.

      Author's profile photo Ahalya Inturi
      Ahalya Inturi

      Very Good document

      Author's profile photo Swetha N
      Swetha N

      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?

      Author's profile photo Former Member
      Former Member

      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)??

      Author's profile photo Rama Shankar
      Rama Shankar

      Useful steps- thanks