SQL2000 SP3a I would like to generate an HTML output file as a report which should be possible. After creating the maintenance plan using the wizard I used the created syntax and established a second job which now uses the changed syntax - however the job doesnt run. In the log file it just states the basic sqlmaint switches.
Current job syntax - SQL uses build in system account.
if by omitting the 2 html-related lines it runs without error, could it be that the version you're trying to run it all does not have this feature implemented yet? i am not sure when html became available for sqlmaint, so you need to confirm that it is for yours.
I am running SP3a and this functionality is described in the according updated BOL. My understanding is that this is supported and working.
I was hoping somebody may have it already working in production.