Re: DB Maintenance Plan seems corrupted

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/26/04 

Date: Thu, 25 Mar 2004 21:06:56 -0600

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....

Relevant Pages

  • Re: OT - Impala SS
    ... >>>That is a symptom of poor investment and funding of the plan. ... >>>They announced that 4000 jobs are to be cut in Canada. ... >As much as a healthy industry is nice and it helps our trade balance, ... >it isn't worth much if it doesn't provide employment. ...
    (rec.motorcycles)
  • Re: Way OT and political, too
    ... but /they/ had the jobs and we did not. ... An invasion plan without a success contingency. ... It makes about as much sense as going to war to kill Saddam Hussein. ... My very simple understanding is probably a consequence of having lived in the mideast for only ten years. ...
    (rec.woodworking)
  • Re: OT: WTF is up with Cheney?
    ... American jobs since February. ... All Obama's "spendalous" plan has done ... The American economy is fueled by private sector jobs ...
    (rec.gambling.poker)
  • Re: OT: WTF is up with Cheney?
    ... and we've lost almost two million jobs since February. ... raise taxes on small businesses, ... His cap and tax energy plan, ... other than cut taxes on the wealthy and let the economy ...
    (rec.gambling.poker)
  • Re: fiat
    ... trade them shares of stock for their I.O.U.'s. ... this number was understated for the reason that the 73,454 jobs ... Today GM admits to another plan to shrink its U.S. assembly line ...
    (rec.autos.makers.ford.mustang)