Defining Report Metrics > Changing Job Status
Version 9.1
Changing Job Status
By default, the Job Summary Report defines the job status as follows:
Table 15.1 Job Summary Metrics
Default Value
12 hours
<200 kilobytes per second
1800 seconds (30 minutes)
Although these values are typical, your SLA might require a different values. You can change these metrics for specific host groups or for all host groups.
To change the job status:
1. Determine the host group’s ID. See Finding the Host Group ID.
2. Log on to the Portal Server as user aptare.
3. Type the following command:
sqlplus portal/portal_password
4. Insert a row into the ptl_sla_group_policy table. The following example assumes that you want to change the metric to 1MB per second for all host groups.
INSERT INTO ptl_group_policy (group_id, policy_name, display_name, seq, numeric_value)
VALUES (100000,'SLOW_JOB_KB_PER_SEC', 'Slow Running Job', 1, 1000);