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.