Oracle Database Discussions

Hi All,

In DBA_JOBS I have scene these details.

THIS_DATE and THIS_SEC columns are having some time.

That means still this job is running?

JOB   LAST_DATE                 THIS_DATE             THIS_SEC      NEXT_DATE

14354  7/9/2014 1:00:04 AM      7/9/2014 1:00:04 AM    01:00:04    7/10/2014 1:00:04 AM

To check whether job is running or not I ran this query.

select count(*) from dba_jobs_running;

This is not returning any records.

It's confusion for me whether the job is running or not.

Could you please confirm.

Thanks.