guillermo martinez

SAP Email query SQL

Posted on Feb 23 at 05:35 PM 13 Views

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?

Add a comment

1 Comment

Jennifer Machado

Feb 23 at 05:35 PM

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!
- Like 0
- Share

0 Answers

Sort by:

Votes

Newest

Oldest

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.

Rules of Engagement

Know someone who can answer? Share a link to this question.

Attachments: Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.