Question

I got a maintenance plan that does a checkdb everyday at
1:00 pm (for example). If i add a job to this maintenance
plan (going to job, adding a step to the job that
exectutes the maintenance plan..) it works fien but when
i open my maintenance plan to alter it (ex: add a
database) i get an error and all my setting are erased.
If i reconfigure it, it creates ANOTHER job using the
previous name and adding a 1 to it.. anyone know why this
is happeneing and how can i work arround this?!?!?!?Don't modify the jobs created by maint wiz. Main wiz is a simple to use tool
for the most basic installations.
If you need customizations beyond maint wiz, create your own jobs (or use Cm
dExec jobsteps to execute
sqlmaint.exe).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"'" <anonymous@.discussions.microsoft.com> wrote in message news:1c53c01c452bd$3c2bda60$a301
280a@.phx.gbl...
> I got a maintenance plan that does a checkdb everyday at
> 1:00 pm (for example). If i add a job to this maintenance
> plan (going to job, adding a step to the job that
> exectutes the maintenance plan..) it works fien but when
> i open my maintenance plan to alter it (ex: add a
> database) i get an error and all my setting are erased.
> If i reconfigure it, it creates ANOTHER job using the
> previous name and adding a 1 to it.. anyone know why this
> is happeneing and how can i work arround this?!?!?!?