MS SQL Server - SP to document maintenance plan ?

Author

SP to document maintenance plan ?

Simo Sentissi

2005-07-28, 8:23 pm

Hello there

I was wondering is there is a stored procedure to witch I could feed the
name of a maintenace job and it will give me all the data that exists in the
maintenance configuration screen ?

thanks

Tibor Karaszi

2005-07-29, 3:23 am

There doesn't seem to be one. Seems like EM builds the maint wiz dialogs by parsing the job
information. I suggest you have a profiler trace running while opening a plan in EM to see what EM
does.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Simo Sentissi" <msentissi@rightnow.com> wrote in message
news:%239h8eM8kFHA.2852@TK2MSFTNGP15.phx.gbl...
> Hello there
>
> I was wondering is there is a stored procedure to witch I could feed the name of a maintenace job
> and it will give me all the data that exists in the maintenance configuration screen ?
>
> thanks
>

Sponsored Links