Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Location
    Huntsville, AL
    Posts
    379
    Provided Answers: 2

    Unanswered: Using Scripting for 'Database Maintenance' Procedures

    Can procedures like defragging the database ('Database Maintenance' / 'Database Optimization') be included in the script to run on certain days? I am curious since this procedure should be run on some sort of regular schedule and oftentimes these 'little' things are overlooked and/or forgotten. The database timers certainly sound equipped to do this but can the actual procedure of defragging be included in the script?
    Thanks,
    Daryl G

  2. #2
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi Daryl
    Can only do manually with menu's as far as I know. You raise a very good point with this request, in that if only we could access menu items via scripts, the power of BD would be increased. In fact only last night I sent a "wish list" request to support which included this ability. While I am not a expert programmer, I image all the menu routines exist in code and only need to be exposed to script engine. any one else have a favorite menu item they would like to access from a script ?
    David

  3. #3
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Can't be done by default using scripts I'm afraid.
    There are ways to attempt it using macros that perform key strokes though. Not really recommended though.

    I think the best solution is to simply use a timer that displays a message once every time you feel the database might need optimisation, telling the user performance can be increased if they optimise the database. Maybe even include a short instruction on how to do it in the pop-up message.

    Just my 2 cents though.

    Regards
    James

  4. #4
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2
    Also you can create a timer with a reminder to defrag the database.

Posting Permissions

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