-
Title
Can't alter scheduler jobs with unnamed arguments -
Description
Steps to reproduce the problem:
Log in as SYS.
Go to SB-Scheduler Jobs and alter the job DRA_REEVALUATE_OPEN_FAILURES.
This job has unnamed parameters.
change the last parameter from 900 to 800.
The script generated by Toad is
BEGIN
SYS.DBMS_SCHEDULER.RESET_JOB_ARGUMENT_VALUE
(job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_name => '');
SYS.DBMS_SCHEDULER.RESET_JOB_ARGUMENT_VALUE
(job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_name => '');
SYS.DBMS_SCHEDULER.RESET_JOB_ARGUMENT_VALUE
(job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_name => '');
SYS.DBMS_SCHEDULER.RESET_JOB_ARGUMENT_VALUE
(job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_name => '');
SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
( job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_position => 1
,argument_value => 'TRUE');
SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
( job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_position => 2
,argument_value => 'TRUE');
SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
( job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_position => 3
,argument_value => 'TRUE');
SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
( job_name => 'SYS.DRA_REEVALUATE_OPEN_FAILURES'
,argument_position => 4
,argument_value => '800');
END;
Bug:Error at line 12
ORA-27453: "" is an invalid job or program argument name.
ORA-06512: at "SYS.DBMS_ISCHED", line 334
ORA-06512: at "SYS.DBMS_SCHEDULER", line 892
ORA-06512: at line 3
Script stopped on line 12.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.