Editing Job Definition In OEM Change Single Qoute To Two Single Qoute Casuing Job To Fail
(Doc ID 1616250.1)
Last updated on SEPTEMBER 15, 2018
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206 and later
Information in this document applies to any platform.
Editing a job in DBConsole adds an extraneous set of quotes in the job definition.
This causes the job to fail.
Below is an example of what is occurring.
Login to 220.127.116.11 Database control
click on 'Server' link.
Click on 'Jobs' link available under 'oracle Scheduler'.
Create a job with definition which has single quotes.
EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname => 'testuser', tabname => 'testtable', method_opt => 'FOR ALL COLUMNS SIZE SKEWONLY', granularity => 'ALL', cascade => TRUE, degree => DBMS_STATS.DEFAULT_DEGREE);
Now save this job. Edit the job and make some changes. For example, include a space and save it.
This adds additional single quotes as given below due to which this job would fail. For example:
EXECUTE DBMS_STATS.GATHER_TABLE_STATS(ownname => ''testuser'', tabname => ''testtable'', method_opt => ''FOR ALL COLUMNS SIZE SKEWONLY'', granularity => ''ALL'', cascade => TRUE, degree => DBMS_STATS.DEFAULT_DEGREE);
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document