Open topic with navigation
Last Updated: 2010-02-17
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:
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.
Command arguments require the following syntax:
M; Path; D; DF; CF (note the single space before M and following each semicolon)
- 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
Arguments must added at the end of the Run field in the Task properties window as shown in the example at right. To open this window:
Arguments must be added to the Add arguments (optional) field in the Edit Action window as shown in the example at right. To open this window:
|Task to perform||Argument||Argument string||Output (DMS 2.51)|
|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|
Copyright © 2013-2016 TimeKeeping Systems, Inc.
Open topic with navigation