[es] - Problem sa radom job-ova

dom

Član broj: 134146
Poruke: 12
213.149.121.*

Profil

^{03.04.2007. u 08:30 - pre 207 meseci}

Imam server i to windows server 2003 i na njemu bazu i to microsoft sql server 2000. Na serveru su postavljeni jobovi da se izvrsavaju(nisam ih ja postavio nego neko drugi).
Od nedjelje dva joba mi se ne izvrsavaju i to jedan radi izgradnju indexa i to ja postavljeno da se radi jednom mjesecno. Greska koja mi se javlja u job history je:

Executed as user: IME\sqlsvcacc. ...contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) DBCC execu... The step failed.

Drugi job je log shipping alert job – restore. I ovo je job koji se izvrsava svaki minut. Greska iz job history je:

Executed as user: IME\sqlsvcacc. The log shipping destination NAZIV.IME_BAZEis out of sync by 2715 minutes. [SQLSTATE 42000] (Error 14421). The step failed.

Hvala unaprijed

Odgovor na temu

logic_rabbit
Radenko Zec
banjaluka

Član broj: 74458
Poruke: 271
*.dialup.blic.net.

+1 Profil

Re: Problem sa radom job-ova

^{05.04.2007. u 22:03 - pre 207 meseci}

Vjerujem za prvu gresku da ti je greska tacno ispred reda
... The step failed.
u te tri tackice.Ovo ispred samo kaze da se DBCC izvrsio.

Za drugu gresku pogledaj(ako vec nisi)
http://www.developmentnow.com/...log-shipping-error-message.htm
tu je opisan isti problem i moguci uzroci.

Nadam se da ce ti ovo biti od pomoci.

logic_rabbit (MCAD,MCSD,MCT,MCTS-
Windows development,MCPD)

Odgovor na temu