Manually Running scheduler Job not show in DBA_SCHEDULER_RUNNING_JOBS (Doc ID 2920133.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When running a job manually, the view dba_scheduler_running_jobs doesn't show the running job.

For example:

1.create a new job:

begin
DBMS_SCHEDULER.CREATE_JOB(job_name=> 'TESTA' ,
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN DBMS_LOCK.SLEEP(''100''); END;',
start_date => sysdate ,
repeat_interval => NULL,
comments => 'test' );

END;
/

2.run this job manually:

exec dbms_scheduler.run_job('TESTA');

3.check view dba_scheduler_running_jobs:

select * from dba_scheduler_running_jobs

                  <<<no any rows return.

Cause

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