Saturday, February 25, 2012

DB Maintenance Plan seems corrupted

Friends,
Does anyone know why a DB Maintenance Plan works fine with
scheduled jobs. Once a notification step is added to the
scheduled job and notification script uses the following
operating system command (cmdExec):
mailsend -d Nextmell.net -smtp NMell-mail -t
rumfell.paul@.nextmell.net,2229999999@.myairmail.com -f
sqladmin@.nextmell.net -sub "landmark- SystemDB DBCC
failed" -m SqladminMail.txt
The maintenance plan looks corrupted although the
scheduled jobs still run fine.
When you click on a plan, it tells you: "One or more jobs
created for this plan has had additional steps added to
it. It is not recommended that jobs created by the
maintenance plan bemodified in anyway." ...The job could
not be parsed. Do you want to ignore it and continue?
Help with above please...This is due to the poor way in which maint plans work. It relies in part on
parsing the strings in the scheduled jobs to determine how to display the
information in the GUI each time you open the wizard. If you change the
wrong thing in the job it can indeed mess up the GUI. In your case it
shouldn't bother anything other than the fact it will warn you since you
added a new step and didn't modify the existing one. Just one of many
reasons why I recommend creating your own jobs and dumping the wizard.
Andrew J. Kelly SQL MVP
"Paul Denver O." <anonymous@.discussions.microsoft.com> wrote in message
news:137d801c412a7$c98806f0$a401280a@.phx
.gbl...
> Friends,
> Does anyone know why a DB Maintenance Plan works fine with
> scheduled jobs. Once a notification step is added to the
> scheduled job and notification script uses the following
> operating system command (cmdExec):
> mailsend -d Nextmell.net -smtp NMell-mail -t
> rumfell.paul@.nextmell.net,2229999999@.myairmail.com -f
> sqladmin@.nextmell.net -sub "landmark- SystemDB DBCC
> failed" -m SqladminMail.txt
> The maintenance plan looks corrupted although the
> scheduled jobs still run fine.
> When you click on a plan, it tells you: "One or more jobs
> created for this plan has had additional steps added to
> it. It is not recommended that jobs created by the
> maintenance plan bemodified in anyway." ...The job could
> not be parsed. Do you want to ignore it and continue?
> Help with above please...

No comments:

Post a Comment