Uipath automation

Question

I want to take the report of last one download details from the mysql database and sent to my project manager on every monday through the email so the process remains same only date would be change dynamically so, I would like to automate this process using RPA UIpath.

Anyone could you help me to achieve this process.

Thanks

Answer 1

To automate this process you need to use the ‘Database’ package and connect to SQL DB and run the query you want to.

Next, you want to retrieve the results in a variable and create a report with variables of time and date which will fetch you current date and time. You can also choose to automate sending the email after this is done

Next, you need to schedule this program to run every Monday which can be done using the uipath orchestrator.