Data Maintenance Scheduler

Published: 2007-05-22

 

Last Updated: 2010-02-17

Applies To

  • Data Maintenance Scheduler versions: 2.51, 3.02

Introduction

Data Maintenance Scheduler (DMS) allows you to create Archive, Backup and Verify Data Integrity tasks using Windows XP Scheduled Tasks or Windows Vista/7 Task Scheduler. DMS is an add-on product for Guard1 Plus 2.7x and earlier and 3.x, and is included with Guard1 Plus 2.8x.

 

Why you should use the Data Maintenance Scheduler:

  • Tasks are automated. Once they are set up, they will run automatically and require no user intervention.
  • DMS allows you to create Backup files directly on a network drive. This provides an added level of data security in the event of a local hard drive failure.
  • You can schedule tasks to run as often as you like.
  • You can create multiple scheduled tasks, and you can run any task at any time by opening Scheduled Tasks (Microsoft XP) or Task Scheduler (Microsoft Vista/Windows 7) and selecting “Run”
  • DMS automatically shuts down Guard1 Plus and the Attendant while the task is running. It will reopen them when the task is complete. This is to ensure that the Master Database is not inadvertently modified in the middle of the task.
  • DMS creates a log file that stores the last 50 tasks that have run, whether successful or unsuccessful.
  • DMS automatically updates the Guard1 Plus Data Maintenance Reminder clock, so that unnecessary reminders are not displayed when you open Guard1 Plus.

 

Refer to the detailed instructions in the file "Guard1 Plus Data Maintenance Scheduler Instructions.doc" that is included with your Data Maintenance Scheduler program or on the Guard1 Plus 2.8x CD. The steps for creating a task and setting up the DMS arguments are shown below.

 

Creating a Scheduled Task for Data Maintenance

NOTE: You must purchase and install Data Maintenance Scheduler before you can use it. If you have Guard1 Plus 2.8x, DMS 2.51 is included and was installed alongside Guard1 Plus.

 

Configuring Data Maintenance Scheduler Tasks

 

Data Maintenance Scheduler uses command arguments to determine what task should be performed. These arguments are added to the Run field (Windows XP) or the Add arguments (optional) field (Windows Vista and 7) of the Task Properties dialog.

 

Using arguments, you can tell DMS which task to perform, where to create Archive and Backup files, and how much data to Archive. You can also specify the date format used in default file names or choose a custom file name. Note on Default file names:

 

* The file extension is .g1p for Guard1 Plus 2.x Archive and Backup files and for Guard1 Plus 3.x Export files.  The file extension is .g13 for Guard1 Plus 3.x Archive and Backup files.

 

Arguments

Command arguments require the following syntax:

M; Path; D; DF; CF (note the single space before M and following each semicolon)

Where:

  • M is the Maintenance Task to perform
    • 1 - Verify Data Integrity (compact and reindex)
    • 2 - Backup (requires Path. DF is optional (will use DF=1 if not specified). If DF is specified, you must include D=0 as a placeholder).
    • 3 - Archive (requires Path and D; DF is optional (will use DF=1 if not specified))
    • 4 - Export (DMS 3.02 only - exports data in Access (.g1p) format for use with Rounds Tracker)
  • Path is the path to an existing folder where you want the Archive or Backup file to be created. This can be a folder on the local hard drive or a network folder. NOTE: DMS 3.02 can NOT create Archives or Backups on a network folder - you must use a local path. The folder must already exist; DMS cannot create a new folder. If you choose a network folder (DMS 2.51 only), the User Account the Task is run under MUST have Modify permissions to the folder. This argument is required if M=2 (Backup) or 3 (Archive).
  • D is the number of days of data to keep in the Master Database when Archiving. All downloads older than this number will be put in the Archive file. This argument is required if M=3 (Archive) and/or you are specifying DF (File Date Format). For example, if D=90, any downloads older than 90 days will be Archived.

 

  • DF is the File Date Format used in the Archive or Backup file name.
    • 1 - mm/dd/yyyy (default – will be used if DF is not specified)
    • 2 - dd/mm/yyyy
    • 3 - yyyy/mm/dd
    • 4 - Custom File Name (valid only for M=2 (Backup)). Use this option if you want to specify the name of the Backup file. You must also include D=0 as a placeholder.

 

  • CF is the Custom File Name. This argument is required if DF=4. Correct syntax is FileName.g1p. WARNING: Using this option can result in loss of data! If a file of the same name exists in the target folder, the original file will be overwritten!

Adding Command Arguments

 

 

 

 

 

Usage Examples

 

 

Task to perform Argument Argument string Output (DMS 2.51)
M Path D DF CF
Verify Data Integrity 1         1 None
Perform a Backup to folder C:\G1P Backups 2 C:\G1P Backups       2; C:\G1P Backups C:\G1P Backups\G1P BU 01-01-2009.g1p

Perform a Backup to network folder* G1P Backupson server MyServer and use yyyy/dd/mm as the date format in the file name

*DMS 2.51 only

2 \\MyServer\G1P Backups 0 3   2; \\MyServer\G1P Backups; 0; 3 \\MyServer\G1P Backups\ G1P BU 2009-01-01.g1p
Perform an Archive to C:\G1P Archives, keeping 30 days of data in the Master Database, and use dd/mm/yyyy as the date format in the file name 3 C:\G1P Archives 30 2   3; C:\G1P Archives; 30; 2 C:\G1P Archives\G1P Archive 1-12-2008 and prior.g1p
Perform a Backup to folder C:\G1P Backups and name the file MyBackup.g1p 2 C:\G1P Backups 0 4 MyBackup.g1p 2; C:\G1P Backups; 0; 4 C:\G1P Backups\MyBackup.g1p

Perform an Archive to network folder* G1P Archives on server Server1, keeping 180 days of data in the Master Database and use yyyy/mm/dd as the date format in the file name

*DMS 2.51 only

3 \\Server1\G1P Archives 180 3   3; \\Server1\G1P Archives; 180; 3 \\Server1\G1P Archives\G1P Archive 2008-12-1 and prior.g1p