sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

Introduce Linux-Compatable Output File Cleanup Job

Open marshallwp opened this issue 4 years ago • 0 comments

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.

marshallwp avatar Mar 03 '21 17:03 marshallwp