I've CE 1.8.0 and cron is working, sitemap is enabled an database table cron_schedule says sitemap_generate success. But sitemap.xml file is missing? What folder it should locate? What do I miss or what would be a tip or answer to get this work?
you can manually generate sitemap.xml from
admin>catalog>Google Sitemap which will resolve missing sitemap.xml issue and also here you find sitemap xml path and
Generally site map is located at yourmagento instance dir