Skip to content

Personal tools
You are here: Home » SQL Server » SQL Server Articles Archive » Scripting Database Maintenance Plans » Figuring out what the wizards are doing.
Seeking new owner for this high-traffic site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3564


Above in this comment thread: Scripting Database Maintenance Plans » Additional Maintenance Plan Info

Figuring out what the wizards are doing.

Posted by johnpaulcook at 2005-12-29 11:28 AM
You are of course correct in not wanting to update sysdbmaintplans directly. Usually the wizards invoke stored procedures to ensure that changes to system tables are done properly. The general approach to figuring out what a wizard actually does is to start SQL Profiler before running the wizard. Everything that the wizard does is captured by SQL Profiler. I used this approach when writing the article.
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!

Powered by Plone