Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: sqlmaint.exe and -HTMLRpt

    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.

    EXECUTE master.dbo.xp_sqlmaint N'-PlanID 89CA81E2-181C-42F9- B39C-59EE21936079
    -HTMLRpt "C:\SystemDbs.html"
    -DelHTMLRpt 1DAY
    -VrfyBackup
    -BkUpMedia DISK
    -BkUpDB
    -UseDefDir
    -DelBkUps 2WEEKS
    -CrBkSubDir
    -BkExt "BAK"'

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    can you run it in query analyzer?

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    It does run when I leave out the 2 lines referencing HTML

  4. #4
    Join Date
    Sep 2003
    Posts
    522
    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.

  5. #5
    Join Date
    Apr 2004
    Posts
    3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •