Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 6 of 6

Thread: Monthly Maintenance Reminder

  1. 06-11-2007, 10:41 AM #1
    Rob is offline Senior Member
    Join Date
    Aug 2004
    Posts
    3,037

    Default Monthly Maintenance Reminder

    Just a reminder that you all should be running the monthly maintenance for your storefronts. Make sure your clients also know to do this.

    This helps prune out old data that just is not needed to be kept (e.g. there is no need to keep credit card numbers, even if encrypted fully, beyond 30, or at most, 60 days). There just is no need.

    The monthly maintenance is found in your admin site under. Misc -> Monthly Maintenance or by clicking the "Monthly Maintenance" link on your admin home page.

    You should get in the habit of performing this monthly. This just keeps the storefront db humming along smoothly over time, so please do not ignore doing this simple step. It takes 1-5 minutes/month.
  2. 06-11-2007, 11:01 AM #2
    silverline is offline Junior Member
    Join Date
    Dec 2006
    Posts
    15

    Default

    Is there any way to schedule this to run automatically once a month?
  3. 06-11-2007, 11:41 AM #3
    ASPDNSF Staff - Andrew Guest

    Default

    At this time there's no way to schedule it to run automatically with 'out of the box' functionality. But, it would make a nice custom mod.....
  4. 06-11-2007, 11:50 AM #4
    Rob is offline Senior Member
    Join Date
    Aug 2004
    Posts
    3,037

    Default

    we remind you on the home page of the admin site every 30 days just click the link.
  5. 06-12-2007, 05:36 AM #5
    Diana is offline Senior Member
    Join Date
    May 2006
    Posts
    179

    Default

    On a dedicated server running a "paid" edition of SQL Server (Workgroup, Standard, etc...Express excluded) you can schedule the aspdnsf_MonthlyMaintenance stored procedure execution using the SQL Server Agent. I think that there is no need to make any custom mod to the site...am I missing something?
    If you run the Express Edition, you can schedule the job by using the sqlcmd utility and .cmd files.
  6. 06-12-2007, 11:17 PM #6
    DotnetKris is offline Member
    Join Date
    Jul 2006
    Location
    Canberra, Australia
    Posts
    62

    Default

    I also can't see any reason why you couldnt use the Windows Task Scheduler and the osql utility to run the stored procedure or a custom script to kick off the stored procedure.

    No custom modification required, just lateral thinking!
    www.dotnetconsulting.com.au