Scheduling queries in background

[Former Member]

How do I schedule Queries in background?

Thanks

[Former Member · Accepted solution]

Shika

other option is You could do this using RSCRM_BAPI.

See this weblogs

https://websmp103.sap-ag.de/~sapdownload/011000358700004400232004E/HowToRSCRM_BAPI.pdf

/people/durairaj.athavanraja/blog

One more option is using Reporting Agent

Hope this helps

Thnaks

Sat

[Former Member]

Can someone explain , in which scenario we will use Reporting agent and when we will use RSCRM_BAPI.

Thanks

[Former Member]

Hi,

You would use 'RACRM_BAI' when you want to retrieve the query contents to a table or file and want to manipulate the data further (by loading the data into any cube or ODS).

Regards

[Former Member]

Shikha

Reporting Agent is used to scheduled in background and it is used when ever you want to assign our own settings to report. Please check this link for more details

http://help.sap.com/saphelp_nw04/helpdata/en/28/734d3caa70ea6fe10000000a114084/frameset.htm

As explained 'RACRM_BAI' if we want to retrieve data to a table or a file and to maniplicate.

Hope this helps

Thnaks

Sat

[Former Member]

1. RSCRM_BAPI is like your infospoke..

2. Reporting agent is like your ind´formation broad casting and alert monitors available..

regards,

Hari

[Former Member]

I think u can use reporting agent to run the queries in background and send the reports.

cheers,

Vishvesh

[Former Member]

In rsa1 u will find reporting agent..

Thr search for query name..then right click on it and choose 'New Setting'..give title and other details..like columns..then save it..

Back out of it..then in right pane see for scheduling packages..create package..give name and description..

U have created a setting for query..drag it and drop it under the package..

Then right click on the package and choose schedule..

schedule it..done..

cheers,

Vishvesh

[Former Member]

hi

check these links

https://websmp103.sap-ag.de/~sapdownload/011000358700004400232004E/HowToRSCRM_BAPI.pdf

/people/durairaj.athavanraja/blog

http://www.bwexpertonline.com/archive/Volume_02_(