Re: SP to document maintenance plan ?

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 07/29/05

  • Next message: Simn: "Re: Can run sp as Administrator but not as User/dbo" 
    Date: Fri, 29 Jul 2005 08:17:06 +0200

    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
>
  • Next message: Simn: "Re: Can run sp as Administrator but not as User/dbo"