Cause

Resolution

Apply the patch to resolve the issue.

• Applicable patches: Patch 156652q or later, Patch 225787y

Caution

Apply the patch through technical support provided by Tmax Tibero.

Note

DBA_JOBS, DBA_JOB_HISTORY views can be queried, and manually execute any JOBs that have not run.

#. Log in as the job creation user
$ tbsql user/user 

#. Execute job
exec dbms_job.run(job_no);

 

Register a Dummy JOB that runs at 2-second intervals to verify operation.

#. Log in as the job creation user
$ tbsql user/user 

DECLARE 
job_no number; 
BEGIN 
DBMS_JOB.SUBMIT(job_no, 'dbms_lock.sleep(1);', SYSDATE, 'SYSDATE+2/86400'); 
END; 
/