Error 'Data source name not found and no default driver specified' when running Clean up History task in maintenance plan in SQL 2022
说明
When running a Cleanup History job in a Maintenance Plan, the job doesn't run and the following error appears:
'Cleanup Backup,Maintenance plan,LiteSpeed history older than '20231207 13:23:00' Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open [1] Execution Time: 0 hrs, 0 mins, 1 secs.'