Knowledge Base > Automation Engine and Target Systems > SAP > Scheduling Queries in Batch Mode

Scheduling Queries in Batch Mode

The transaction RSCRM_BAPI can be used to create queries for your BW system. The result is stored either in a table or a file. Use AE to make queries either regularly or upon request.

In the first step, log on to the BW system and call the transaction RSCRM_BAPI. Schedule the query to be automated with AE once. Each query has its own batch ID. Open the batch monitor and copy this number.

 

Now create a SAP jobAn Automation Engine object type for a process that runs on a target system. in your AE system. Use the Form tab or write the following functionPre-defined run book template in the Automation Engine. One single step only, e.g. Start Windows Service, Copy file,… directly into the Process tab:

R3_ACTIVATE_REPORT REP='RSCRMREPORT_BAPI'

Now change to the SAP tab and enter the copied BatchID in the field Job name.

This Job objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task can now be integrated in your processing (e.g. in a Schedule object) and will process the query at the point in time you define.

It is a SAP peculiarity that the batch monitor does not display all query executions but only the last one.

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH