Getting "ORA-27469: LOG_HISTORY is not a valid job attribute" while changing scheduler job attribute log_history (Doc ID 3024312.1)

Last updated on JULY 20, 2024

Applies to:

Goal

Getting "ORA-27469: LOG_HISTORY is not a valid job attribute" while changing scheduler job attribute log_history as below.

BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => 'TEST_JOB_SCH',
attribute => 'LOG_HISTORY',
value => 45
);
END;
/  2    3    4    5    6    7    8
BEGIN
*
ERROR at line 1:
ORA-27469: LOG_HISTORY is not a valid job attribute
ORA-06512: at "SYS.DBMS_ISCHED", line 3246
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3085
ORA-06512: at line 2

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.