I need the suggestion on the below error where sql agent job fails with the below error and upon rerun it got suceeed , but i need to investigate on what caused this issue , any suggestions are appreciated
The OLE DB provider "MSDASQL" for linked server "" reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000] (Error 7399) Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "L" for linked server "". The provider supports the interface, but returns a failure code when it is used. [SQLSTATE 42000] (Error 7311). The step failed.