If you choose to create custom jobs by modifying the job templates provided, use the information provided in the following table.

Table 1. Environmental variables for database maintenance jobs
Job OpenEdge Management variable Description
Database Backup FM_BKPDEVICE Identifies the backup device, which is either the tape or complete path to the file.
Database Backup FM_BKPDEVICETYPE Indicates the type of device to be used—disk or tape.
Database Backup FM_BKPTAPEDIR Identifies the full tape device name. This name can match the value defined for FM_BKPDEVICE.
Database Backup FM_BKPDIRECTORY Identifies the directory for file backup.
Database Backup FM_BKPFILENAME Identifies the filename for file backup.
Database Backup FM_BKPOVERWRITEFILE Indicates whether a file, but not a tape, is overwritten.
Database Backup FM_BKPONLINE Identifies the option that determines whether to perform a backup job online or offline. If this option is not set, OpenEdge Management assumes the backup is offline.
Database Backup FM_BKPINCREMENTAL Indicates whether data in blocks that have been changed since the last backup will be backed up.
Database Backup FM_BKPESTIMATESIZE Indicates whether a report that estimates the size of the backup will be generated.
Database Backup FM_BKPVERBOSELISTING Indicates whether OpenEdge Management provides a verbose output every 10 seconds giving the status of the backup.
Database Backup FM_BKPCOMPRESSION Indicates whether you want data blocks compressed as they are backed up.
Database Backup FM_BKPNORECOVERY Used for mirrored backups. Set this option if you do not want the database to be able to roll forward an AI file.
Database Backup FM_BKPVOLUMESIZE Identifies the size that you want the backup to be before prompting for another volume.
Database Backup FM_BKPBLOCKINGFACTOR Specifies the blocking factor size used to flush buffers out of the backup device.
Database Backup FM_BKPREDUNDANCYFACTOR Specifies the count to create redundancy in the backup.
Database Restore FM_RSTDEVICE Identifies the device to which the database is restored. The device can be either a tape or a complete path to a file.
Database Restore FM_RSTDEVICETYPE Indicates the type of device to be used—disk or tape.
Database Restore FM_RSTVERIFY Identifies one of three possible restore options:
  • Partial verification
  • Full verification
  • Creation of a structure file from the backup that was completed
Database Restore FM_RSTDBNAME Identifies the full path and name of the database you want to restore.
GrowBI FM_BICLUSTERNUMBER The number of clusters to pregrow the BI file to when the command is run. The initial size of the BI file is determined by taking the BI cluster size times the BICLUSTERNUMBER.
Database Analysis FM_DBAUTILIZATIONNUMBER Specifies the percentage of utilization of the blocks for the index to validate against.
Database Analysis FM_COMPACTIONNUMBER Specifies the percentage to which indexes will be packed when index compaction is run.
Database Analysis FM_DBABLOCKNUMBER Specifies the threshold for the number of blocks that the index must contain for the rule to be run.
Database Analysis FM_DBARULEVALIDATION Indicates that you want this job to test your rules.
Index Compaction FM_IDXTABLENAME Identifies the name of the table to compact.
Index Compaction FM_IDXINDEXNAME Identifies the name of the index to compact.
Index Compaction FM_COMPACTIONNUMBER Specifies the percentage to which indexes will be packed when index compaction is run.
All database maintenance jobs FM_ADMINSERVERNAME Specifies the resource's AdminServer and the resource. For example: Dev01.sports2000.