Scheduled Task On Plesk (External XML > SQL)

- An XML feed hosted on a different website needs to be scraped daily at a specific time of the night - The scraped data (some, not all of it - only about half of the fields in the XML file) needs to be inserted / updated into an MSSQL database, either overwriting the previous data or deleting it then adding it, whatever is easiest. Each node / row in the XML file contains a unique identifier which should be how the database info is managed - Table and fields already created in database, these match the fields in the XML file. Not every field in the XML file needs copying -Images listed in the XML file need to be copied over to a folder on the website. It may be necessary that a separate folder is created for each property as some of the images have the same names Notes: - the website is hosted on a Plesk control panel - code should be a scheduled task / similar - not click to run - code needs to be annotated so I can update if necessary in the future