OnePoint Reindex SQL Job failed
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
OnePoint Reindex SQL Job failed

 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM
Author Message
Micha@Siemens
Guest
Posted: Tue Jan 04, 2005 4:41 pm    Post subject: OnePoint Reindex SQL Job failed Reply with quote
On our SQL Server the OnePoint Reindex Job failed with the following error:
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.

Does someone know something about this problem?

Regards, Michael
Back to top
James Morey
Guest
Posted: Wed Jan 05, 2005 12:31 am    Post subject: Re: OnePoint Reindex SQL Job failed Reply with quote
Michael,

Did you get a "A MOM SQL Server Agent job failed" alert in the MOM Operator
console? If, so did you try the Product Knowledge for this alert?

Let me know if the Product Knowledge isn't helpful.

--
=====================
NOTE - This posting is provided "AS IS" with no warranties, and confers no
rights.

James Morey | Microsoft | Windows & Enterprise Management Division
=====================


"Micha@Siemens" <MichaSiemens@discussions.microsoft.com> wrote in message
news:0B7EBD20-98C8-49A7-9C1E-6577D3FBB8DD@microsoft.com...
Quote:
On our SQL Server the OnePoint Reindex Job failed with the following
error:
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
42000]
(Error 22029). The step failed.

Does someone know something about this problem?

Regards, Michael
Back to top
Guest
Posted: Wed Jan 05, 2005 2:50 pm    Post subject: OnePoint Reindex SQL Job failed Reply with quote
Hi Michael

Set SQL Server Properties -> Server Settings -> Server
Behavior -> Query Cost greater than 600

Cheers
Nils


Quote:
-----Original Message-----
On our SQL Server the OnePoint Reindex Job failed with
the following error:
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe
failed. [SQLSTATE 42000]
(Error 22029). The step failed.

Does someone know something about this problem?

Regards, Michael
.
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB