Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to confirm whether DBMS_JOB is running or not.

ramya_162Jul 9 2014 — edited Jul 10 2014

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2014
Added on Jul 9 2014
7 comments
3,431 views