We have a request to automate query execution every day and email the results to the user.
This query should be scheduled to execute every day at 6:00AM in the morning.
We cannot use Information broadcaster. We need permission to install it, which would have to go through many channels.
I tried to look into RSCRM_BAPI. But with this feature we can only save the query results as a .csv file on a file server.
Any other approach that could solve my problem, would be highly appreciated.