Post reply

-DelHtmlRpt not working.

  • January 15, 2004 at 10:02 am

    #152017

    We are running a SQLMAINT job, which is creating HTML reports but the -DelHtmlRpt 5days option is not deleting them. Has anyone else experienced this problem and found a work around? The full command is as follows.

    SQLMAINT.EXE -S ServerName -U User -P "Password" -D BPMAIN -CkDB -CkAl -HtmlRpt "f:\Microsoft SQL Server\MSSQL\data\Support\BPMAIN_opt.htm" -DelHtmlRpt 5days -UpdOptiStats 80 -RebldIdx 20

    We are running SQL Server 2000, service pack 3 on Windows 2000 service pack 4.

  • February 2, 2004 at 4:44 am

    #492462

    I have discovered a work around for this problem. If you include the -Rpt and -DelTxtRpt flags the -DelHtmlRpt flag is forced to work. The time arguments for -DelTxtRpt and -DelHtmlRpt can be different so you only need to keep one copy of the text report if you want.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply