Skip to Content
author's profile photo Former Member
Former Member

Background jobs classification for BW ETTL

Dear Gurus

We have around 110+ jobs are available in system. From there Basis guys will segregate few for Dialog and few for Background jobs and further for Background jobs classifies based on priority.

I would like to know, for BW data loading(night mode) is it better to have more background jobs and a bit less DIA jobs or vice versa?

We are using BI 7.0 data flow.


When we load data into DSO, we need run DTP and then we run activation job. Here do we need more background jobs or DIA jobs?

We have night mode settings as,

BGD : 65

DIA : 45

Thank you all.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 14, 2012 at 07:55 AM

    the activation of dso is usually one bgd job. however if you activate more then one request at the time, you can choose to activate them in parallel and then of course you need more background jobs.

    the same goes for dtp's. in the settings for parallel processing you can set the number of parallel background jobs needed (ie the number of packets processed at the same time). you can find this setting in the menu "goto" in the dtp maintenance.

    so 1 dtp can use eg 3 bgd jobs (standard setting), but you can choose as well to use 5 bgd jobs.

    from my experience i would say that your ratio is correct. but again it depends of many other factors.

    you can check this in the morning easily... in sm37 look at the delay of the jobs. if a lot of jobs have a delay, it means that at that moment there were not enough background jobs available. you can solve this issue by adding background jobs, or by shifting the loads, a bit earlier, or a bit later...

    it always takes a while and some trial and error before the overnight loading schedule is optimized...

    to check the runtime of process chains visually there is a how to paper:

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.