Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cblatchford
Starting Member
40 Posts |
 Posted - 2007-06-01 : 05:57:57
|
| Hi all,Since Tuesday evening this week, after some DNS and WINS settings were changed here at the firm (not necessarily related but highly coincidental!) several SQL jobs on a few servers have been failing intermittently. Specifically the error messages which come up in the job history are as follows:Executed as user: EMEA\SYS-SQLADMIN-LON. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.I can run the jobs manually, and 50% of the time they will complete OK. I've re-registered the linked servers and can successfully connect to them OK. I've checked the time-out option and for the time-being set it to 5000 which should be more than enough.Each of the jobs that fail are referencing a linked server.As the jobs work half the time it would appear to be a network/timeout issue, but I can't seem to work out specifically what is causing the failures!As mentioned briefly before, there were DNS and WINS changes made Tuesday night when the jobs started to fail.Any help appreciated and needed ASAP!Many thanks |
|
|
|
|
|
SQL Jobs - Linked servers