Home All Groups Group Topic Archive Search About

SQLMaint.exe Utility

Author
16 Apr 2007 8:20 PM
Saravanan
Hello All,

I am using the sqlmaint utility to backup my database and transaction log. I
am using the DelHtmlRpt option and the DelHtmlRpt option to generate HTML
report and trying to delete reports that are older than 7 days. Below is part
of the command

-HtmlRpt \\mpl1itsbkp001\sql_temp\mpl1itssql007\wmd_prd\reports\wmd_prd_Tlogs_Report.html -DelHtmlRpt 7days

But I am not able to make the sqlmaint delete the HTML report files and I am
seeing that many had reported with no solution. Could you please help me with
this ?

I am using SQL Server Enterprise Edition with SP4.

Thanks to anybody who could throw some light.
--
Saravanan

AddThis Social Bookmark Button