Hi,
I have scheduled a job to run everyday night. The job is failing sometimes and not always with this error.
OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312). The step failed.
If I run the job again without changing anything, it runs perfectly.
What could be the problem?
Thanks
P.C. Vaidyanathanpermissions are the problem. your sql agent is running under a different user.. the account you are logged into has permissions to do the job and most likely sql agent doesnt.
Showing posts with label sqloledb. Show all posts
Showing posts with label sqloledb. Show all posts
Subscribe to:
Posts (Atom)