topic Re: SAP Email query SQL in Application Development and Automation Discussions

SAP Email query SQL

Former Member — Tue, 23 Feb 2021 17:35:12 GMT

I have a scheduled report to be emailed to several people.

This report is updated at 5am and finishes at 8am aproximately with SQL procedures.

We have a table we can query to check if that procedure has finished by inserting a "T" in one column.

The problem is that sometimes this actualization extends beyond 8am so the report is sent without being fully actualized.

Is there a possibility to not send this reports until this actualization finishes by querying the table to see if there is a T in a field?

Re: SAP Email query SQL

former_member34 — Tue, 23 Feb 2021 17:35:36 GMT

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Many thanks!