OraFAQ Forum: SQL & PL/SQL » How to find Currently running jobs?

Home » SQL & PL/SQL » SQL & PL/SQL » How to find Currently running jobs? (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find Currently running jobs? [message #581190]

Wed, 03 April 2013 02:36

bsm.java
Messages: 5
Registered: January 2013
Location: Singapore

Junior Member

Hi,

I am trying to find a way to identify what are the user_jobs currently running. I have found 1 way which requires DBA User ID to execute (e.g. DBA_JOBS and DBA_JOBS_RUNNING) which I don't want.

I believe there is NO equivalent User table for DBA_JOBS_RUNNING table.

I have done my 20 mins search in this forum and unable to find. Can anyone please help?

Thanks & Regards,
Senthil

Report message to a moderator

Re: How to find Currently running jobs? [message #581191 is a reply to message #581190]

Wed, 03 April 2013 02:47

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

try ALL_ or USER_ views.

regards,
Delna

Report message to a moderator

Re: How to find Currently running jobs? [message #581192 is a reply to message #581190]

Wed, 03 April 2013 02:59

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

USER_SCHEDULER_RUNNING_JOBS or ALL_SCHEDULER_RUNNING_JOBS is there for you.

regards,
Delna

Report message to a moderator

Re: How to find Currently running jobs? [message #581195 is a reply to message #581192]

Wed, 03 April 2013 03:32

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can work out which which jobs are running from user_jobs.
Look at the this_date column.

Report message to a moderator

Re: How to find Currently running jobs? [message #581196 is a reply to message #581192]

Wed, 03 April 2013 03:34

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

These views does not give the same information than dba_jobs_running. These are not the same jobs.
There are no standard USER/ALL views for old jobs.

Regards
Michel

[Updated on: Wed, 03 April 2013 04:54]

Report message to a moderator

Re: How to find Currently running jobs? [message #581197 is a reply to message #581196]

Wed, 03 April 2013 03:55

bsm.java
Messages: 5
Registered: January 2013
Location: Singapore

Junior Member

Hi All,

Thanks for your quick responses. I understood that there is no equivalent for dba_jobs_running for user level. Hence I am convinced to use THIS_DATE/THIS_SEC attributes since I just wanted to know whether my job is running or not. Hope I am right.

Thanks & Regards,
Senthil

Report message to a moderator

Re: How to find Currently running jobs? [message #581198 is a reply to message #581197]

Wed, 03 April 2013 04:19

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

if the job is running, THIS_DATE is not null in USER_JOBS.

you can query USER_SCHEDULER_RUNNING_JOBS for you currently running scheduled jobs.

regards,
Delna

Report message to a moderator

Re: How to find Currently running jobs? [message #581199 is a reply to message #581198]

Wed, 03 April 2013 04:22

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

@Delna - OP is using dbms_job not dbms_scheduler. Scheduler views are no use to them.

Report message to a moderator

Re: How to find Currently running jobs? [message #581206 is a reply to message #581199]

Wed, 03 April 2013 06:13

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

oh right! Thanks cookiemonster.

regards,
Delna

Report message to a moderator

Previous Topic:	ReDefintion
Next Topic:	partition of table - error in materialized view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 24 20:54:24 CDT 2025