Re: Job names for database maintenance plans

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I've created several database maintenance plans and I create the schedule
within the database maintenance plan. This creates a job name the same as
the database maintenance plan name with the subplan name appended. When I
open up the job schedule properties within the database maintenance plans,
it
defaults the name of the job, but one can override it. However, the job
does
not get saved with the name of the job that you type in. I've found that
you
can rename the job, but if you open up the database maintenance plan and
save
it, the job gets renamed. Is this how it is designed to work? Seems a
bit
odd. Is there a way to preserve the job name one gives it? We are using
SQL
Server 2005 Standard SP2.

The name gets replaced by the MP wizard I /think/ because it either
identifies the existing job to update by ID, or it deletes the old job and
creates a new one (I don't have the energy right now to test which one
happens). Unfortunately, there doesn't seem to be a way to make your
override stick.

Was it designed intentionally this way? Probably not; probably more of an
oversight. But you could file a suggestion at
connect.microsoft.com/SQLServer to make them aware of the issue (they may
not know that this "feature" bothers anyone).


.