I have a stored procedure that calls remote query using a linked server. It
works fine when I run it manually through the Query analyzer window, but when
ever I try to schedule it as a job it fails with:
Could not create an instance of OLE DB provider 'IBMDASQL'. [SQLSTATE
42000] (Error 7302) (Error 7302) OLE DB error trace [Non-interface error:
CoCreate of DSO for IBMDASQL returned 0x80040154]. [SQLSTATE 01000] (Error
7300). The step failed.

we have a similar process that use the same method and they run fine in the
scheduler, so what makes this proc different? any suggestions/thoughts would
be highly appreciated. I have also tried creating the job using the same
service account that runs SQL Service