Changing job status
By default, the Job Summary Report defines the job status as follows:
Table: 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:
Determine the host group's ID.
Log on to the Portal Server as user aptare.
Type the following command:
sqlplus portal/<portal_password>@//localhost:1521/scdb
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', 'SlowRunning Job', 1000); commit;