Home > Administer Data Miner > Workflow Throughput > Change Oracle Scheduler Job...
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