finding outcome of maintanence plan

20 Sep 2007 6:30 PM

light_wt

What are the ways to find the outcome details of maintinence plan?
Is it something have to do with
Activity monitor, sqlagent.out, file_yyy.mm.dd?

Thanks.

20 Sep 2007 8:56 PM

Tibor Karaszi

In the maint plan, you can specify a report file to be produced. This contains details of the
execution performed by the MP. Also, Agent will tell you success/failure of the whole execution.

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

Show quote

"light_wt" <ligh***@discussions.microsoft.com> wrote in message
news:BF209028-2FEB-4ACF-BD3A-3718A3BA2E76@microsoft.com...
> What are the ways to find the outcome details of maintinence plan?
> Is it something have to do with
> Activity monitor, sqlagent.out, file_yyy.mm.dd?
>
> Thanks.

20 Sep 2007 11:14 PM

light_wt

Thanks Tibor.

I've heard there are two different ways. one is storing as a file and what
is the other?

21 Sep 2007 1:49 PM

Tibor Karaszi

The maint plan history table. I think it always writes to this. You should find it in the msdb
database, and perhaps SSMS can display this history if you right-click the plan (I don't have a
setup to try on at the moment).

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

Show quote

"light_wt" <ligh***@discussions.microsoft.com> wrote in message
news:90329914-A927-40AA-85DA-DE1D20E4C17D@microsoft.com...
> Thanks Tibor.
>
> I've heard there are two different ways. one is storing as a file and what
> is the other?
>
>