August 28, 2011 at 10:23 am
I have a maintence plan called reorg that did some thing like check database integrity, update statistics, reorgnize index, delete old history.
But it failed this weekend, from the job history I can see the error log as below,
Serversqlserver1
Job NameReOrg.ReOrg
Step NameReOrg
Duration00:52:52
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: mycompany\sqlservices33. ...00:14:42.61 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2011-08-28 00:14:44.56 Source: Check Database Integrity Task Executing query "USE [mydb1] ".: 50% complete End Progress Progress: 2011-08-28 00:16:08.06 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2011-08-28 00:16:08.13 Source: Check Database Integrity Task Executing query "USE [mydb2] ".: 50% complete End Progress Progress: 2011-08-28 00:17:20.47 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2011-08-28 00:17:21.83 Source: Check Database Integrity Task Executing query "USE [mydb... The return value was unknown. The process exit code was -107374... The step failed.
I cannot see which step was errored out. I tried to see the history in maintence plan, there is nothing recorded for today's run.
where can I find out which step it failed and what was the reason it failed.
Thanks
August 28, 2011 at 1:23 pm
You need to check the maintenance plan history - not the agent job history. To do that, right-click on the maintenance plan in Object Explorer and view history.
This will show you all of the tasks in the maintenance plan - and which one failed. Once you find the one that failed, in the bottom of the window the error text will be displayed. Note: this is not very easy to read because of the size - so I copy/paste the text into notepad to view.
If you have any issues figuring out what failed and why, please post back and we'll help you figure it out.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 28, 2011 at 3:01 pm
Thanks,
I did check the maintence plan history, see the last lines in my original post, there is not a record for today's run in the history, the last run was previous Sunday.
So I cannot find any information about today's run in maintenance history.
I was surprised too to see there is not a row for today's failed run.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply