LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022 (4376875)

LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022

Cleanup history step errors when LiteSpeed runs on SQL 2022

Click To See Full Image.

SQL Server 2022 does not include ODBC driver as part of the setup. The ODBC driver is a LiteSpeed pre-requisite.
 

Install SQL Native Client 12 

https://www.microsoft.com/en-US/download/details.aspx?id=50402?1558859051

Workaround: Edit the current maintenance plan Disable Cleanup history step Add exec T-SQL step with command exec [LiteSpeedLocal]..[LiteSpeed_DeleteActivity] @delLocal=1,@purgeDeleted=1, @delLogshipping=1, @delStatus=1, @delUnit=3, @delUnitType='DAYS' In the example above history older than 3 days will be purged. (@delUnit=3) These arguments can be configured as desired: @delUnit= Any integer @delUnitType='[HOURS, DAYS, WEEKS, MONTHS, YEARS]'