Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in RPA by (12.8k points)

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

1 Answer

0 votes
by (29.8k points)

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.  

Related questions

0 votes
1 answer
0 votes
1 answer
asked Nov 20, 2020 in RPA by dev_sk2311 (43.2k points)
0 votes
1 answer
asked Nov 20, 2020 in RPA by dev_sk2311 (43.2k points)
0 votes
1 answer
0 votes
1 answer
asked Nov 20, 2020 in RPA by dev_sk2311 (43.2k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.6k users

Browse Categories

...