Change Oracle Scheduler Job Class

Data Miner Workflows are submitted to run as Oracle Scheduler Jobs. Oracle Scheduler has a number of ways to control how system resources are managed. Administrators use these facilities to effectively manage a large pool of run requests from Oracle Scheduler users.

Data Miner uses the default Oracle Scheduler job class DEFAULT_JOB_CLASS as its own default. You can change the job class by setting the Data Miner Repository value WORKFLOW_JOB_CLASS.

This script changes WORKFLOW_JOB_CLASS from DEFAULT_JOB_CLASS to MINING_CLASS, a job class previously defined by the administrator for data mining jobs:

set echo on;
-- value of WORKFLOW_JOB_CLASS before update
select property_name, property_str_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'WORKFLOW_JOB_CLASS';
-- update WORKFLOW_JOB_CLASS
UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES
SET property_str_value = 'MINING_CLASS'
where property_name = 'WORKFLOW_JOB_CLASS';
-- commit change
commit;
-- value of WORKFLOW_JOB_CLASS after update
select property_name, property_str_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'WORKFLOW_JOB_CLASS';

The following log is produced when you run the script:

-- value of WORKFLOW_JOB_CLASS before update
 
select property_name, property_str_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'WORKFLOW_JOB_CLASS'
 
PROPERTY_NAME PROPERTY_STR_VALUE
------------------------------ ------------------------------
WORKFLOW_JOB_CLASS DEFAULT_JOB_CLASS
 
-- update WORKFLOW_JOB_CLASS
 
UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES
SET property_str_value = 'MINING_CLASS'
where property_name = 'WORKFLOW_JOB_CLASS'
 
1 rows updated
-- commit change
 
commit
 
commited
-- value of WORKFLOW_JOB_CLASS after update
 
select property_name, property_str_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES
where property_name = 'WORKFLOW_JOB_CLASS'
 
PROPERTY_NAME PROPERTY_STR_VALUE
------------------------------ ------------------------------
WORKFLOW_JOB_CLASS MINING_CLASS