batch jobs where and how

[Former Member]

Hello BW Experts,

1) Where and why do we use batch jobs in BW?

2) where and why do we use the batch jobs in R/3 ?

3) how do we monitor them

4) how do we start and stop them ?

Thanks,

BWer

[edwin_harpino · Accepted solution]

hi,

batch job, relate to batch process, one of the type of process in WAS (in relation with BW). the type of process are :

- dialog-DIA, used for processing dialog program, e.g awb-administrator workbench, bw monitor.

- batch-BTC, used for any kind of process submitted for batch processing, e.g data load process, aggregate rollups, infocube compression.

- update-UPD, used for asynchronous updates, e.g v1 and v2. this type not used in BW.

- enqueue-ENQ, used for locking and unlocking objects.

- spool-SPO, used for execute print requests.

Now, the batch job :

1. where ?

load process, aggregate rollups, infocube compression.

the job name can be identified start with BI_xx e.g :

- BI_BATCHxxx trigger to r/3

- BI_REQUxxx load to data target

- BI_ODSAxxx activate ods data

- BI_STRUxxx attribute/hierarchy change run

- BI_STATxxx statistics

- BI_DELxxxx delete data/request

- BI_AGGRxxx aggregate rollups

...

process chain job : BI_PROCESSxxx

others

- RSIMPCURR - currency update

- RSIMPCUST - transfer global setting

...

why ?

processing make take long time.

2. in r/3 (related to bw)

- extraction triggered by bw

BI_REQUxxx with user name background user (aleremote)

(need to check job name for currency and transfer global setting)

- generic extraction using program scheduled background

- fill setup table (olibw) : job name : RMCVNEU

- V3 collective run : LIS_*_datetime; * = application

...

3. how do we monitor ?

• transaction sm37

• for data loading->bw monitoring

4. start and stop ?

start

• data loading : infopackage scheduling, process chain

• sm36

stop : sm37-> cancel job.

...

hope this helps.

[Former Member]

Hi,

1) SM37, we use batch jobs to schedule certain tasks in background.

4) You can define a new job in SM36 and review them SM37.

Hope it helps!!!!

Regards,

Amit

[Former Member]

Amit,

Thanks for the reply,

other than setup table purpose what other purpose we might use the batch job. Could you please throw some light on this.

Thanks,

BWer

[Former Member]

Hi Bwer,

Batch jobs or background jobs can be handy in so many situation. Usually, a batch job will take a background work process. Usually the time out set for dialogue work process will be less as to evenly devide system resource into all the users. So some jobs which runs long, might timeout if u run these in dialogue work process. So u schedule this as a batch job. Any program can be run in background(batch) by selecting program->execute-> background.

Even in case of process chains, there will be a batch job waiting for each process types, which waits for the previous process to finish and then runs in background. U can monitor all these in SM37.

Hope this helped u. Please post again if ur not clear.

[Former Member]

Hi BWer,

2. Let suppose when you want to fill the setup table at Lo-cockpit then you can creates multiple jobs with different intervals and you can runs. These jobs are called batch jobs.

3. Regarding o monitoring of job then go to T.code sm37 for those jobs status.

4. To start ant stop the job again you need to go T.code sm37.

Regards,

PRK