The more often you update and publish new content, the more often you should generate a sitemap.
As a general rule, we recommend auditing your sitemap once per month. If you publish multiple pieces of content per day, you may need to update your sitemap on a weekly basis.
Just keep an eye out for errors. Which is easy with the Site Audit tool.