Data services job taking 6-9 Hrs

[siba_pkd21]

Hi Team,

A recurring jobs running for every 4 hours. But each of it's execution took 6 to 9 Hrs to complete successfully. Because of this, many times some executions are running in parallel i.e., if one execution not finished in 4 Hrs , then the next execution will start after 4 Hrs so there will be  2 executions runs in parallel which could impact performane as well as end user not getting data on time. So kindly suggest on this.

Regards

Siba

[Julian_Riegel]

Hi @siba_pkd21 ,

there are many reasons which could cause that and it is quite hard to give an answer without further background information.

Here are some helpful hints:

1. Read & get familiar with the following blog to try and optimize this job. https://community.sap.com/t5/technology-blogs-by-sap/let-the-database-do-the-hard-work-better-perfor...

2. If extracting high data volumes from a SAP ERP/ECC, use ABAP Dataflows preferably

3. Try to push down as many operations as possible to the Database

4. Make sure your DS Version is compatible with the DBMS. Upgrade DS as well as the DBMS to the most up to date versions compatible as per PAM

5. Try to parallelize the Dataflows wherever possible

6. Check the ressource consumptions of the Data Services Jobserver when such jobs are running and size accordingly

BR,

Julian