Share via

How to run multiple SQL script on every Monday which will generate different-2 reports in CSV format that needs to be send to multiple recipients

Ankit2526 0 Reputation points
2023-04-25T09:18:44.2666667+00:00

Hi, My scenario is, I have multiple SQL scripts which are generating multiple reports those reports need to be send to multiple recipients on every Monday. how can I build this solution. DB used is Postgres DB. Thank in Advance. Regards, Ankit

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,542 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Subashri Vasudevan 11,226 Reputation points
    2023-04-27T11:53:11.47+00:00

    Hi @Ankit2526

    You could use that query in the source of copy activity. And sink can be mapped to data Lake storage. This will be creating report in csv/txt format (however you have created data set)

    Reference video: https://youtu.be/k2lz83rrFxk

    For running it every Monday , you can create a schedule trigger for every week, and choose Monday.

    Reference video: https://www.cathrinewilhelmsen.net/triggers-azure-data-factory/

    For sending mail, you can use logic app.

    Reference Video: https://youtu.be/wNJhhT0DDMM

    Please let us know if you need more details.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.