Platform Deployment Guide › Data Warehouse › Advanced Configuration › Change the Job Frequency › Change the Job Frequency on Oracle CMSs

Change the Job Frequency on Oracle CMSs

Note: If you change the job frequency, you must be logged onto the CMS database as the primary user. This is the account that CA DataMinder uses to access the CMS database.

You can specify a repeat interval for a specified data warehousing job. First, you need to check the job name and confirm its next run time. Then you set the job frequency.

Syntax

Check the Job Name

Run the following SQL query:

SELECT OWNER, JOB_NAME, SUBSTR(REPEAT_INTERVAL,1,40) 
AS REPEAT_INTERVAL, 
NEXT_RUN_DATE 
FROM ALL_SCHEDULER_JOBS;

This query returns the JOB_NAME value.

Set the Job Frequency

Run the following PL/SQL command. This example sets the job to run at 2:00 AM every night:

BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE
(name => 'DLP_AGGREGATION_<DBNAME>',
attribute => 'repeat_interval', 
value => 'FREQ=<Period>; <Frequency>' );
END;

Where:

DLP_AGGREGATION_<DBNAME> is the JOB_NAME returned from the first SQL query.

<Period> and <Frequency> are DBMS_SCHEDULER parameters that define the job schedule.

Examples

The following example sets the job to run at 2:00 AM every night:

BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE
(name => 'DLP_AGGREGATION_<DBNAME>',
attribute => 'repeat_interval', 
value => 'FREQ=DAILY; BYHOUR=2' );
END;

The following example sets the job to run every 3 hours:

BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE
(name => 'DLP_AGGREGATION_<DBNAME>',
attribute => 'repeat_interval', 
value => 'FREQ=HOURLY; interval=3' );
END;

See your Oracle documentation for full DBMS_SCHEDULER details.