563053 Sitemap Generation

My site structure has changed so my Python script is no longer generating the correct links. I need a program/script that will walk through my database and generate active links, making xml files that contain no more than 50,000 links each, and then and then save them to a directory on my website. I would like the program/script to run on a schedule. I will have a list of static links that should be at the beginning of the first xml file, and then the rest should be programatically generated based on a set criteria for URL generation. I have a .asp function that generates the URLs, and need this new program/script to follow that same logic. I'm attaching a sample file from Google's basic sitemap structure.