Changing Job Status
By default, the Job Summary Report defines the job status as follows:
Table 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:
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 (300000,'SLOW_JOB_KB_PER_SEC', 'Slow
Running Job', 1000);
commit; |