Hi, Please give some system table details or SQL query to fetch maintenance plan details on server through SQL QUERY.
Required table results:-
I write query that gives information about available maintenance plan details but want to fetch few give above column also.
Order by name,subplan_name
The following query will give you the details of the maintenance plan and any job and schedule details that are available for it.
The only issue here is that you cannot interrogate the maintenance plan to find the databases you would be working on (as far as I know).
Maintenance plans are actually SSIS packages that are stored inside SQL Server. You can find the binary data for the package in the system table
The actual package is in the column
answered Apr 19 '12 at 08:09 AM