Skip to Content

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

December 4, 2013 | 2,707 Views |
 -exec.bat4.1bodscmdcommand promptscheduling
Follow

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 🙂

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  5. Former Member

    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?

    (0) 

Leave a Reply