Scheduler Job Which Is Scheduled To Run Monthly Is Running Weekly (Doc ID 2030465.1)

Last updated on JULY 14, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

DBMS_SCHEDULER job is configured to run on monthly basis on Friday. However its running on weekly basis.

Example:


BEGIN
 DBMS_SCHEDULER.create_job (
   job_name   => 'MY_TEST_JOB',
   job_type   => 'PLSQL_BLOCK',
   job_action => 'BEGIN NULL; END;',
   repeat_interval => 'freq=monthly; byday=FRI; byhour=02; byminute=05; bysecond=0;',
   end_date        => NULL,
   enabled         => TRUE,
   END;
/

SQL> select  next_run_date from dba_scheduler_jobs where job_name= 'MY_TEST_JOB';

NEXT_RUN_DATE
---------------------------------------------------------------------------
17-JUL-15 02.05.00.769459 AM PST8PDT
====Which is after 1 week

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms