I admit that this is new to me.
I have a SQL Server 2005, where I created a linked server to an Oracle database(Remote). I can view the catalogs on the remote. I have a job set up, to initiate the linked server, to download certain records at night.
While I am logged onto the server, sometimes even if I am "disconnected", the jobs just fine.
However, If I log off the server, the job will launch, but within 1 second, it fails, with error message saying
"Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server..."
The SQL Agent is running as a domain user account.
Never seen this before. Any help you can offer is appreciated.