Introduces a version of the Output File Cleanup job that is written in T-SQL and is compatible with SQL Server 2017 CU18+ on all platforms.
It relies upon master.sys.xp_delete_files (the plural version) that was introduced with SQL Server 2019 and back-ported to SQL Server 2017 with CU18. master.sys.dm_os_enumerate_filesystem is also used, but that was introduced with SQL Server 2017 so it doesn't impact compatability as much as xp_delete_files.
Due to the loop it is slower than the cmd version so that version will continue to be used on Windows hosts.
Introduces a version of the Output File Cleanup job that is written in T-SQL and is compatible with SQL Server 2017 CU18+ on all platforms.
It relies upon master.sys.xp_delete_files (the plural version) that was introduced with SQL Server 2019 and back-ported to SQL Server 2017 with CU18. master.sys.dm_os_enumerate_filesystem is also used, but that was introduced with SQL Server 2017 so it doesn't impact compatability as much as xp_delete_files.
Due to the loop it is slower than the cmd version so that version will continue to be used on Windows hosts.