January 15, 2004 at 10:02 am
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.
January 19, 2004 at 8:00 am
This was removed by the editor as SPAM
February 2, 2004 at 4:44 am
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply