I have a job that runs nightly.
Intermittently it gets Code: 0xC020801E ---The connection manager "Microsoft OLE DB Provider for SQL Server" is an incorrect type. The type required is "FILE". The type available to the component is "OLEDB". End Error.
It will run fine for days or a week in a row without this error but then have it twice in one week. I kick the sql agent off manually the next morning without rebooting or any other changes and it will work fine.
I have seen response for jobs that have not run at all ,but this job runs each night and has run over a week successfully at times without this error.
Any suggestions would be appreciated.