Job fails

[vaidyanathanpc]

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. Vaidyanathan

 

[Guest_imported]

When you say i run it again do you mean in a DTS package or if you manually start the job


Are you using Mapped drives anywhere in this JOB if so change to Full PATH name

 

[Guest_imported]

Go into the JOB
Right click -- to view job history
then
CHECK the ChECK BOX -- to show step details

Now what step is the error on
what is that part doing??????

 

[vaidyanathanpc]

I right click on the job and start in again. Sometimes it runs sometimes it does not...
In the view job history, the error mentioned above is displayed..
Is there any limit on the number of linked servers that can be created?

Regards,
P.C. Vaidyanathan