question

narendba avatar image
narendba asked

How to found objects in rebuild maintainance plane?

We have a rebuild maintainance plane for around 40 selected tables... So how to get the list of those selected tables which are scheduled rebuild maintainance plane?
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KenJ avatar image
KenJ answered
To find the list of tables for which a maintenance plan will rebuild indexes, you need to open the maintenance plan, open the properties of the index rebuild task then view the list of tables for which it will rebuild indexes. Because the maintenance plans are SSIS based, the table names aren't stored in a table where you can query them although, if you're up for it, Jamie Thomson has some queries for accessing SSIS package properties, so you could query your maintenance package for it's tables with a bit of XQuery creativity: [ http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx][1] If you're plans are stored in the MSDB repository, just query the package out of msdb.dbo.sysssispackages table instead of the filesystem. [1]: http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.