Try OpenEdge Now
skip to main content
Database Management
Database Maintenance Job Templates : Creating database maintenance job instances : Setting up a Database Analysis job

Setting up a Database Analysis job

The Database Analysis job runs against an OpenEdge database and loads the information into the OpenEdge Management Trend Database. This information can be used for various purposes, including index compaction and data analysis.
To complete the Database Analysis Properties page:
1. Provide values for the Name and Description fields.
2. Select the database for which you want to perform this analysis from the Resources list.
3. Select the Enable rule validation option to indicate that you want this job to test your rules. Utilization % and Block number, two subfields of the Enable rule validation option, are active only if you select this option. Complete these subfields as follows:
a. In the Utilization % field, specify the percentage of utilization of the blocks for the index to validate against. If the index utilization percentage goes below this number, you could set up an alert to trigger.
b. In the Block number field, specify the threshold for the number of blocks that the index must contain for the rule to be run.
4. Select the Run index compaction option if you want index compaction run for the database during this job. The Compaction % field specifies the percentage to which indexes will be packed when index compaction is run.
5. Verify the command's current working directory in the Working directory field. If specified, this directory must exist. This property defaults to the OpenEdge Management working directory defined at installation.
6. To append subsequent messages to the .out or .err files, select the Append option. The Output file field indicates where messages will be retained.
7. Select the Debug log file option to obtain diagnostic details that help debug job properties when setting up a job. For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, OpenEdge Management makes debug data available through the debug log file link on the Job Summary page.
8. Select the Indicate if the job can be used as an action option if you want this job to appear in the list of actions that can be selected for execution from the Alerts and Job completion action page.
9. If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field to display the Job Completion Actions and Alerts page. See OpenEdge Management: Resource Monitoring for more information about the Job Completion Actions and Alerts page.
10. Click Save. The Job Summary page appears. You can now schedule the job to run at a later time, or you can run it immediately. You can also edit advanced information. See Editing advanced job information for additional details.