Maintenance Plan

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tolcis - 07 Jul 2008 14:07 GMT

Hi,

I setup an Integrity and Optimization job to be ran once a week on one
of my SQL 2005 Servers. The job failed over the weekend.
This is the output that I get:

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3054
Report was generated on "inf-sql1".
Maintenance Plan: All Databases
Duration: 00:00:02
Status: Warning: One or more tasks failed..
Details:
Check Database Integrity Task (inf-sql1)
Check Database integrity on Local server connection
Databases that have a compatibility level of 70 (SQL Server version
7.0) will be skipped.
Databases: All databases
Include indexes
Task start: 2008-06-29T01:00:01.
Task end: 2008-06-29T01:00:04.
Failed:(0) Alter failed for Server 'inf-sql1'.

I am puzzled by this line: Status: Warning: One or more tasks failed..
also by this: Failed:(0) Alter failed for Server 'inf-sql1'. How can
I see more detailed output and see at what step job failed? Also, why
does it say Failed (0) but one component failed?

T.

Reply to this Message

Andrew J. Kelly - 07 Jul 2008 14:40 GMT

Have a look in the maintenance plan history (not the job history) for more
details.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Hi,
>
[quoted text clipped - 25 lines]
>
> T.

Reply to this Message

tolcis - 07 Jul 2008 14:54 GMT

On Jul 7, 9:40 am, "Andrew J. Kelly" <sqlmvpnooos...@shadhawk.com>
wrote:

> Have a look in the maintenance plan history (not the job history) for more
> details.
[quoted text clipped - 32 lines]
>
> > T.

Ok, I found that Check Database Integrity Task failed but how would I
know which database is the suspect? It just shows the Task Name, Task
Detail and Error number (0). That is it.

T.

Reply to this Message

Tibor Karaszi - 07 Jul 2008 17:28 GMT

How about the report file? Did you specify such?
(My guess is that you should remove the "attempt to repair minor problems" options in your plan...)

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> On Jul 7, 9:40 am, "Andrew J. Kelly" <sqlmvpnooos...@shadhawk.com>
> wrote:
[quoted text clipped - 40 lines]
>
> T.

Reply to this Message

tolcis - 07 Jul 2008 22:04 GMT

On Jul 7, 12:28 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:

> How about the report file? Did you specify such?
> (My guess is that you should remove the "attempt to repair minor problems" options in your plan...)
[quoted text clipped - 50 lines]
>
> > T.

where can I specify that report?

Reply to this Message

Tibor Karaszi - 08 Jul 2008 05:58 GMT

> where can I specify that report?

In the maint plan. I believe the right-most tab. Also check out the other suggestion ("...minor
problems...").

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> On Jul 7, 12:28 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
[quoted text clipped - 56 lines]
>
> where can I specify that report?

Reply to this Message