Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ABrown
Starting Member
9 Posts |
 Posted - 2005-04-17 : 13:52:27
|
| I read comments in this forum that the Maintenance Plan wizard is not the best way to execute a maintenance plan. What are the cons of using the wizard other than less control? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-18 : 01:01:39
|
| from experience, errors are very difficult to troubleshoot, i end up recreating the entire package in the end (simply because, i can't understand which step was executed first, which to step over to and so on)--------------------keeping it simple... |
 |
|
|
ABrown
Starting Member
9 Posts |
Posted - 2005-04-18 : 14:43:26
|
| How do you execute a maintenance plan then and what do you include? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-18 : 22:00:20
|
| it depends on what type of maintenance you're planning to perform.try exploring, jobs, alerts, data transformation services (DTS),basically the plans are executed as jobs and scheduled to run at specified period(s)--------------------keeping it simple... |
|
|
|
|
|
|
SQL Server Maintenance Plan Wizard