CODEWITHSUNDEEP
schedulerhanasap-data-services
kishorre
kishorre

Reputation: 57

Check scheduled job status in SAP BODS

I am new to BODS, At present I have configured a job to execute every 2 minutes to perform transaction from MySQL server and load into HANA tables.

But sometimes when the data volume in MySQL is too large to transform and load into HANA within 2 minutes, the job is still executing my next iteration for the same job starts which results in BODS failure.

My question is: is there is any option BODS to check for the execution status of the scheduled job between runs?

Please help me out with this.

Upvotes: 1

Views: 2302

Answers (1)

Pankaj
Pankaj

Reputation: 11

You can create a control/audit table to keep history of each run of bods job. The table should contain fields like eExtractionStart, ExtractionEnd, EndTime etc. And you need to make a change in the job, so that it reads status of previous run from this table before starting the load to Hana data flow. If previous run has not finished, the job can raise an exception.

Let me know if this has been helpful or if you need more information.

Upvotes: 1

Related Questions