Defining Report Metrics > Changing Job Status
  
Version 9.2.00
Changing Job Status
By default, the Job Summary Report defines the job status as follows:
Table 15.1 Job Summary Metrics
Metric
Default Value
LONG_JOB_HOURS_DEFAULT
12 hours
SLOW_JOB_DEFAULT
<200 kilobytes per second
STALLED_JOB_DEFAULT
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, numeric_value)
VALUES (100000,'SLOW_JOB_KB_PER_SEC', 'Slow
Running Job', 1000);
commit;