My Oracle Support Banner

Column LAST_DATE of USER_JOBS Does Not Get Updated After Run Job Manually In Oracle 19C (Doc ID 2647906.1)

Last updated on MARCH 17, 2020

Applies to:

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

Symptoms

The column last_date of user_jobs does not get updated after run job manually in Oracle 19C.

Version: oracle 19.3, CDB/PDB

Test case:

-- Create test table:
create table wp_test(a number);

-- Create schedule job:
declare
  JobNo user_jobs.job%TYPE;
  BEGIN
  dbms_job.submit(
  job => JobNo,
  what => 'begin execute immediate ''insert into wp_test select 1 from dual''; end;',
  next_date => SYSDATE,
  interval => 'SYSDATE + 1/1440');
  dbms_output.put_line(
  chr(10)||'Job No. is: '||JobNo||',Should run this job in 1 minute (at '||
  to_char(sysdate+ 1/1440)||')');
  COMMIT;
  END;
  /

-- Run the job manually, the job no is 71 from user_jobs.

execute dbms_job.run(71);

-- Check the test and user_tables.

The row can be inserted into table wp_test, but the column last_date and last_sec of user_jobs not get updated.

select * from user_jobs;

 

EXPECTED BEHAVIOR
-----------------------
The columns last_date and last_sec of user_jobs to be updated when the job is ran manually.

Changes

Upgrade to 19c.

Cause

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
Symptoms
Changes
Cause
Solution
References


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