|
|
|
date: Fri, 3 Oct 2008 14:52:25 -0400,
group: microsoft.public.sqlserver.server
back
Re: Maintenance Plan Logging.
I get a failed job message with no real detail, so I was going to rely on
the log to get down to the problem. If I disable all of the step except the
index rebuild it works. If I only enable that, it fails. I can run some
traces or run the rebuilds manually, but I really want to know why that step
is not logging at all when the others do. I am actually less concerned (at
this point) with the job failure than the lack of logging for testing it.
"Andrew J. Kelly" wrote in message
news:OA3PMZBKJHA.4936@TK2MSFTNGP04.phx.gbl...
> OK I get that part, but what is the core problem you are having. You say
> you are "having problems on the rebuild index". What kind of problems?
> What are the symptoms. If there is no logging the step may not have
> anything to do but we need details of why you think there is a problem.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Shawn" wrote in message
> news:%23YuNA2AKJHA.5336@TK2MSFTNGP05.phx.gbl...
>> When I set the log path in the maintenance plan, all the steps in the job
>> are output to the log file, but not the rebuild index step. It is just
>> blank.
>>
>> "Andrew J. Kelly" wrote in message
>> news:%23FJiYA8JJHA.4672@TK2MSFTNGP05.phx.gbl...
>>> What exactly do you mean by "turning on Logging"? And what is the
>>> actual problem?
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>> Solid Quality Mentors
>>>
>>>
>>> "Shawn" wrote in message
>>> news:eP1NKX7JJHA.3976@TK2MSFTNGP03.phx.gbl...
>>>>I am planning on doing that next, but I do want to know why that part of
>>>>the job is not being logged as well.
>>>>
>>>> "Andrew J. Kelly" wrote in message
>>>> news:%23veptYaJJHA.4280@TK2MSFTNGP04.phx.gbl...
>>>>> Can you be more specific on what kind of problems you are having?
>>>>> Have you tried running a trace?
>>>>>
>>>>> --
>>>>> Andrew J. Kelly SQL MVP
>>>>> Solid Quality Mentors
>>>>>
>>>>>
>>>>> "Shawn" wrote in message
>>>>> news:eKvjukYJJHA.5900@TK2MSFTNGP02.phx.gbl...
>>>>>>I have a SQL 2005 (Enterprise 9.0.3042) cluster that is having
>>>>>>problems in the "Rebuild Index" section of the maintenance plan. So, I
>>>>>>turned on logging to get to the bottom of it, but that section is not
>>>>>>logged. Even if I disable all the other parts it still does not show
>>>>>>anything in the log file. This is not a problem on my other SQL
>>>>>>Servers.
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
date: Mon, 6 Oct 2008 22:05:24 -0400
author: Shawn
Re: Maintenance Plan Logging.
It is hard to say why the MP's do anything as they are so poorly designed in
many cases and just one reason why I avoid them. I suspect the logging may
have something to do with the severity of the error is so high that it exits
before it can even log. I would definitely recommend tracing that step and
make sure to include the beginning and ending events along with the errors
and exceptions ones as well. If the trace doesn't tell you enough you can
take the actual command it is sending to SQL Server and paste that into the
Query Editor where you should get a decent error message and idea of what is
going on.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Shawn" wrote in message
news:eaSZMECKJHA.4772@TK2MSFTNGP03.phx.gbl...
>I get a failed job message with no real detail, so I was going to rely on
>the log to get down to the problem. If I disable all of the step except the
>index rebuild it works. If I only enable that, it fails. I can run some
>traces or run the rebuilds manually, but I really want to know why that
>step is not logging at all when the others do. I am actually less concerned
>(at this point) with the job failure than the lack of logging for testing
>it.
>
> "Andrew J. Kelly" wrote in message
> news:OA3PMZBKJHA.4936@TK2MSFTNGP04.phx.gbl...
>> OK I get that part, but what is the core problem you are having. You say
>> you are "having problems on the rebuild index". What kind of problems?
>> What are the symptoms. If there is no logging the step may not have
>> anything to do but we need details of why you think there is a problem.
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>>
>> "Shawn" wrote in message
>> news:%23YuNA2AKJHA.5336@TK2MSFTNGP05.phx.gbl...
>>> When I set the log path in the maintenance plan, all the steps in the
>>> job are output to the log file, but not the rebuild index step. It is
>>> just blank.
>>>
>>> "Andrew J. Kelly" wrote in message
>>> news:%23FJiYA8JJHA.4672@TK2MSFTNGP05.phx.gbl...
>>>> What exactly do you mean by "turning on Logging"? And what is the
>>>> actual problem?
>>>>
>>>> --
>>>> Andrew J. Kelly SQL MVP
>>>> Solid Quality Mentors
>>>>
>>>>
>>>> "Shawn" wrote in message
>>>> news:eP1NKX7JJHA.3976@TK2MSFTNGP03.phx.gbl...
>>>>>I am planning on doing that next, but I do want to know why that part
>>>>>of the job is not being logged as well.
>>>>>
>>>>> "Andrew J. Kelly" wrote in message
>>>>> news:%23veptYaJJHA.4280@TK2MSFTNGP04.phx.gbl...
>>>>>> Can you be more specific on what kind of problems you are having?
>>>>>> Have you tried running a trace?
>>>>>>
>>>>>> --
>>>>>> Andrew J. Kelly SQL MVP
>>>>>> Solid Quality Mentors
>>>>>>
>>>>>>
>>>>>> "Shawn" wrote in message
>>>>>> news:eKvjukYJJHA.5900@TK2MSFTNGP02.phx.gbl...
>>>>>>>I have a SQL 2005 (Enterprise 9.0.3042) cluster that is having
>>>>>>>problems in the "Rebuild Index" section of the maintenance plan. So,
>>>>>>>I turned on logging to get to the bottom of it, but that section is
>>>>>>>not logged. Even if I disable all the other parts it still does not
>>>>>>>show anything in the log file. This is not a problem on my other SQL
>>>>>>>Servers.
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
date: Tue, 7 Oct 2008 09:46:02 -0400
author: Andrew J. Kelly
|
|
