February 16, 2003 at 7:39 pm
I have created a integrity check job DB maintenance plan for Master and MSDB DB. The job failed
as "Executed as user: ABC\serviceSQL. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
Is anyone can tell me the problem?
Thank in advance
February 17, 2003 at 6:09 am
Maybe the coude inside the Job fails. You should check that first. Or list an example of the code here.
February 17, 2003 at 5:53 pm
I have recreated the job, the problem still happen..
February 18, 2003 at 6:11 am
Look at the history for the maintenance plan, not the job itself. You can filter to only show failed jobs.
Andy
February 18, 2003 at 11:51 pm
Hi Andy, Thank for you reply.
The maintetance plan history display an error as below..
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error:
Object ID 2073058421, index ID 2.
The low key value on page (1:3595) (level 0)
is not >= the key value in the parent (1:1421)
slot 201.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error:
Object ID 2073058421, index ID 2. The high key value on page (1:4614)
(level 0) is not less than the low key value in the parent (0:1),
slot 0 of the next page (1:21147).
[Microsoft][ODBC SQL Server Driver][SQL Server]
Table error: Object ID 2073058421, ind
The Object ID 2073058421 is in the MSDB DB sysjobhistory Table. Please advise what to do next?
February 19, 2003 at 3:32 am
Run DBCC CHECKTABLE against that table or DBCC CHECKDB against MSDB and see if it reports any errors.
February 20, 2003 at 1:36 am
This is a bug: (bug id 352452) or see MS knowledge base article 290622
(I also had the problem)
February 28, 2003 at 8:25 pm
Antares686, I ran DBCC CHECKTABLE (sysjobhistory, REPAIR_ALLOW_DATA_LOSS ) command, and the error was repaired and fix, Thank for your infor.
FVC, The bug occur when the Integrity option in attempt to repair any minor problems was selected. The option need to disable.
Thanks All.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply