With out scheduling how to trigger BODS jobs automatically when data base tables get updated

[former_member619115]

Can any one give detailed information about how to run BODS batch jobs automatically when data base table get updated.Some where I saw that by below process we can achieve..

>>From DB side want to create Trigger on a particular table which we used in the job and then Trigger will call Web services and Web services will Trigger BODS jobs automatically when changes happen.

>>Please guide me is this process is correct if it is I need a great help Step by step process how to implement from this SAP BODS Community.

>>Else give few more suggestions to implement this requirement.

Thank you.

[former_member574686 · Accepted solution]

Hello ,

You may follow the below mentioned steps

1. Create .sh/.bat file using export execution command in BODS management console for the job to be executed. Executing .sh/.bat file will trigger the BODS job
2. Create a package/procedure (I’m assuming that you are using oracle database) in database to execute the .sh/.bat
3. Define the trigger on the particular Table for DML activities which executes the package created in step 2.This will execute the BODS job

As far as using SAP web services are concerned , you may have to call 3 web services in sequence and the task will be little tedious.

Here are the steps to achieve this

1. Create a Oracle procedure/Package which invokes the below mentioned web services Published by SAP

• Logon - To logon to BODS CMS and get the session id
• RUN_BATCH_JOB – Executes a particular BODS job. Session id should be given as input
• Logout – Logout from the session

2. Define the trigger on the particular Table for DML activities which executes the package created in previous step. This will execute the BODS job.

Having said that , you should have a through knowledge on SOAP , WSDL to build the procedure to invoke the web services.

[former_member619115]

Hi,

Thank you very much for your support we have done this task by creating insert trigger with .bat file of a particular job when we insert a record job gets triggered.

>>If we use this process how was the performance impact?

Thanks,

Kanshi y

[former_member619115]

Hai Vinayak Bhat,

Thanks for your response I have few quires..

• Logon - To logon to BODS CMS and get the session id
• RUN_BATCH_JOB – Executes a particular BODS job. Session id should be given as input.

>>Is session id and run id is same if not from where can i get exactly in CMS?

>>How to use session id for RUN_BATCH_JOB and let me know more about this please.

Thank you.

[former_member574686]

Hello,

If you really want to use the Webservices published by SAP to launch the BODS Job , please go through below mentioned link

https://help.sap.com/viewer/ab33122a997f40d89e340549ff0bced8/4.2.9/en-US/574996556d6d1014b3fc9283b0e...

Session ID and Run ID are completely different. Session ID generated when you log on to CMS and RunID is generated when the job execution started.

As I mentioned before , using web services to launch the BODS batch job will be little tedious.

You may use tools like SoapUI to understand how exactly different webservices works and what are the Inputs and Outputs.

Thanks,

Vinayak BHAT