SP to document maintenance plan ?

microsoft.public.sqlserver.programming

28 Jul 2005 10:24 PM

Simo Sentissi

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

29 Jul 2005 6:17 AM

Tibor Karaszi

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/

Show quote

"Simo Sentissi" <msenti***@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
>