Monday, March 12, 2012

Job Fails

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.

No comments:

Post a Comment